|
Re: looking for solution on how to load date through sqlldr [message #70006 is a reply to message #70005] |
Tue, 02 April 2002 01:19 |
Sujit Mahapatra
Messages: 19 Registered: March 2002
|
Junior Member |
|
|
You can use the following:
Case 1:
(Where the fields are delimited, say by comma and the input file has date field format as "dd-mon-yyyy")
Load Data
infile 'infile.txt'
replace
into table table
fields terminated by "," optionally enclosed by '"'
(
... ,
DATE_FROM DATE "DD-Mon-yyyy",
...
)
Case 2:
(When you have fixed length format fields)
you can put it in the control file as:
...
date_field POSITION(49:56) DATE "YYYYMMDD",
...
And so on...
There are some more ways. But still the above two cover almost all major cases.
Does this help?
|
|
|