Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE WC_APPLICATION_EVENT_F22 ( 
JOB_INFO_ROW_WID NUMBER(5), 
PI_CANDIDATE_NUM NUMBER(5), 
CANDIDATE_NAME VARCHAR2(15) NOT NULL, 
PI_HIS_ITM_APP_TRK_CREATION_DT DATE, 
PI_HIS_ITM_APP_TRK_STEP_NAME VARCHAR2(15), 
PI_HIS_ITM_APP_TRK_STS_NAME VARCHAR2(15));
INSERT INTO WC_APPLICATION_EVENT_F22 
(JOB_INFO_ROW_WID 
, PI_CANDIDATE_NUM
, CANDIDATE_NAME 
, PI_HIS_ITM_APP_TRK_CREATION_DT
, PI_HIS_ITM_APP_TRK_STEP_NAME
, PI_HIS_ITM_APP_TRK_STS_NAME ) 
VALUES 
(4160
, 75485
, 'John K'
, (TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'))
, 'Offer'
, 'Accepted');
1 rows affected

Select * from WC_APPLICATION_EVENT_F22


JOB_INFO_ROW_WID
PI_CANDIDATE_NUM
CANDIDATE_NAME
PI_HIS_ITM_APP_TRK_CREATION_DT
PI_HIS_ITM_APP_TRK_STEP_NAME
PI_HIS_ITM_APP_TRK_STS_NAME


4160
75485
John K
03-MAY-03
Offer
Accepted