problem loading date format field using sql*loader [message #365800] |
Fri, 04 February 2000 16:24 |
karunakar pabba
Messages: 5 Registered: February 2000
|
Junior Member |
|
|
Hi
I have date format in my data file like 'mmddyy'and if i transfer data using sql* loader its loading but the year is loading as 2000 instead of 19xx,and also i need to use trailing nullcols in my control file as there is no data for some of columns.
Should i use to_char or to_date function in my control file please send me the syntaxes with examples.
My data file is having ',' as field separator and also enclosed in '"' for character data type field.
Thanks in advance
-- karun
|
|
|