OraFAQ Forum: Server Utilities » how to upload date fied using sql*loader

Home » RDBMS Server » Server Utilities » how to upload date fied using sql*loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to upload date fied using sql*loader [message #73161]

Mon, 23 February 2004 03:42

Ankur
Messages: 22
Registered: August 2000

Junior Member

Hi,

I am trying to upload a | separated file using SQL*Loader. In my table there are 2 date fields. And the data is in format mm/dd/yyyy.� In the control file I have given:

start_date char separated by &#124,

Can somebody tell me the way to upload the data.

Ankur

PS:�If I remove�the date field, file gets uploaded without any problem.

�

�

�

�

Report message to a moderator

Re: how to upload date fied using sql*loader [message #73164 is a reply to message #73161]

Mon, 23 February 2004 06:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please post a sample datafile and table structure

Report message to a moderator

Re: how to upload date fied using sql*loader [message #73172 is a reply to message #73161]

Wed, 25 February 2004 03:46

Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA

Senior Member

LOAD DATA
INFILE 'your_data_file.dat'
REPLACE
INTO TABLE your_table
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
start_date "to_date (:start_date, 'mm/dd/yyyy')"
)

Report message to a moderator

Previous Topic:	Downgrade 9i to 8i
Next Topic:	cannot mount database in exclusive mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:07:29 CDT 2024