Home » RDBMS Server » Server Utilities » looking for solution on how to load date through sqlldr
looking for solution on how to load date through sqlldr [message #70005] Tue, 02 April 2002 00:55 Go to next message
Achuta venu
Messages: 1
Registered: April 2002
Junior Member
How do i export date field data into oracle tables through a control file using SQLLDR
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 Go to previous message
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?
Previous Topic: Re: OCP Exam Papers
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Mon Dec 05 08:27:02 CST 2022