| SQL LOADER data file error problem with date [message #72085] |
Wed, 05 March 2003 06:46 |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
In my CSV file i have the date field as '1/1/2001'.But in my control file i gave
UPDT_DATE DATE 'MM/DD/YYYY',
But the field can contain '12/12/2003' also.
Moreover sometimes the same date field in CSV file can contain time stamp also...
How to handle this problem???
2).Can i give absolute input data file path name in control file?.
3).I need to have same control file and input file for loading more than one table.
Here the first 50 records are for table1,the next 50 are for table2 and the rest are for table3.
Any idea????
Thanks
~V~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
