Another ? on sql ldr- date format

[badrinathn]

Hi,
I have a text file containing a date field. The date field appears in (YYYYMMDD format ex: '200010121'), however the field in the table is a date field.
How can I convert this YYYYMMDD format to 'DD-MON-YY' format while loading into table using sqlldr.

Help me ,

Badrinath

[sreddy]

DATE
The data field contains character data that should be converted to an Oracle date using the specified date mask.
For example:

LOAD DATA
INTO TABLE DATES (COL_A POSITION (1:15) DATE "DD-Mon-YYYY")
BEGINDATA
1-Jan-1991
1-Apr-1991 28-Feb-1991

See the documentation for rest of details.

[url]http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch05.htm#20324[/url]