OraFAQ Forum: Server Utilities » Getting date from header of csv and load it to a table

Home » RDBMS Server » Server Utilities » Getting date from header of csv and load it to a table

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

Getting date from header of csv and load it to a table [message #292135]

Tue, 08 January 2008 00:01

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

Hi,

Asset Summary,01042008 09:17:08,23975

this is the header of the csv file.
I have to get the date and put it in a table in the mm/dd/yyyy format.(the format in the table is mmddyyyy).using sqlloader.
In control file, how can I get it?

Please advice.

[Updated on: Tue, 08 January 2008 00:02]

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292144 is a reply to message #292135]

Tue, 08 January 2008 00:49

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I have to get the date and put it in a table in the mm/dd/yyyy format

Date datatype doesn't have a format, you choose the format when you query the value.

Regards
Michel

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292146 is a reply to message #292144]

Tue, 08 January 2008 00:53

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

Ok..Can I have the date atleast?

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292151 is a reply to message #292135]

Tue, 08 January 2008 01:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>..Can I have the date atleast?
Sure, why not.

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292153 is a reply to message #292146]

Tue, 08 January 2008 01:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes:
Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section SQL*Loader Datatypes
Subsection Datetime and Interval Datatypes

Regards
Michel

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292224 is a reply to message #292151]

Tue, 08 January 2008 04:09

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

How can I read that date from the header?
I am new to use the control files.

Please advice.

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292225 is a reply to message #292224]

Tue, 08 January 2008 04:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

And you'll remain "new" unless you start creating control files on your own. Do the initial effort, write you own version and - if it doesn't work, come back.

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292227 is a reply to message #292225]

Tue, 08 January 2008 04:17

vanathi
Messages: 74
Registered: December 2007
Location: India

Member

I am continuing my teammate's work.
The control files are already there. I have to modify it.

Report message to a moderator

Re: Getting date from header of csv and load it to a table [message #292235 is a reply to message #292227]

Tue, 08 January 2008 04:33

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So post it but before read the link I posted and explain why you can't do it with this link.

Regards
Michel

Report message to a moderator

Previous Topic:	oracle export
Next Topic:	Import & Export Partition tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:55:47 CST 2024