i have a problem with sql loader
i want to load dates in a field and route bad formats to bad file i use the following control file:
INTO TABLE temp_x
FIELDS TERMINATED BY X'9'
x_date date "DD-MON-YY"
the problem is that it loads also '08-JUL-1' but i want to reject this record so allow only this format DD-MON-YY and reject this DD-MON-Y
any ideas? i havent get more...
thanks in advance