Home » RDBMS Server » Server Utilities » sqlldr: loading data with date
sqlldr: loading data with date [message #219708] Thu, 15 February 2007 10:46 Go to next message
syang
Messages: 30
Registered: February 2007
Member
Hi All,

Does anyone know how to load data (with sqlloader) that has the following date pattern?

1. 12/27/2006 12:39:36 PM
2. 1/17/2007 7:03:03 AM

How will the control file be setup in order to deal with this date pattern?

...
(SUPLR_ID,
LGL_BUSNS_NAME,
LAST_CHG_DT date "mm/dd/yyyy hh:mm:ss")

My question is how to interprete this "PM and AM" in the control file.

Thanks for your advice!

Re: sqlldr: loading data with date [message #219711 is a reply to message #219708] Thu, 15 February 2007 10:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use
"mm/dd/yyyy HH:MI:SS AM"
Re: sqlldr: loading data with date [message #219713 is a reply to message #219711] Thu, 15 February 2007 11:04 Go to previous messageGo to next message
syang
Messages: 30
Registered: February 2007
Member
Thank you, Mahesh!

Your answer has solved my problem. Data has been successfully loaded after the fix. Thank you, gain!
Importing CSV File in oracle table using TOAD [message #219956 is a reply to message #219708] Sat, 17 February 2007 00:00 Go to previous messageGo to next message
farrisoft
Messages: 1
Registered: February 2007
Location: Pakistan
Junior Member

Hi,
i have a .csv file in excel & i wanna import it into a table
in oracle 8i. but i m using TOAD tool for the oracle. plz guide
me how to make the control file .ctl & how to use the sql
loader. but all these within the TOAD.
regards,
Farrukh
Re: sqlldr: loading data with date [message #219966 is a reply to message #219708] Sat, 17 February 2007 00:44 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>how to use the sql loader. but all these within the TOAD.
Those who live by the GUI, die by the GUI.
SQLLDR is NOT a GUI utlity. It is command line driven. Deal with it.
Previous Topic: need document on export / import transportable TS
Next Topic: Not Null Constraints Disappeared after import
Goto Forum:
  


Current Time: Sat Dec 10 20:18:10 CST 2016

Total time taken to generate the page: 0.06055 seconds