I need to load data into a table depending upon a particular date . suppose in the flat file I have last 100 years historic data . But I want only last 50 year's data , into the table .For that I wrote the control file , but it's not working .
INTO TABLE T1
--FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
--WHEN TO_DATE(DOB,'YYYYMMDD') > TO_DATE('19540101','YYYYMMDD')
NAME position(1:4) CHAR
,DOB position(5:12) DATE "YYYYMMDD"