Home » Other » Client Tools » Importing sysdate and Sequence into table from .csv using SQL Developer (SQL Developer 1.5.1 on Mac OSX 10.5.4)
Importing sysdate and Sequence into table from .csv using SQL Developer [message #356139] Wed, 29 October 2008 13:26 Go to next message
joannadarling
Messages: 1
Registered: October 2008
Junior Member
I do not have Oracle installed, but I do have SQL Developer. I am trying to import a .csv file. The table I'm importing into has a timestamp field that I want to set to sysdate. It also has an ID field that is a sequence number.

HOW do I import so that the sequence number increments, and the timestamp field is correctly set to sysdate? I haven't been able to figure it out..

Thanks
Joanna

Report message to a moderator

Re: Importing sysdate and Sequence into table from .csv using SQL Developer [message #360906 is a reply to message #356139] Mon, 24 November 2008 05:47 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It's easy to do from SQL*Loader (you should have it as it's part of the client install). See "Can one modify data as the database gets loaded?" in the SQL*Loader FAQ.

Best of luck!

Frank

Report message to a moderator

Previous Topic: SET ECHO OFF does not work
Next Topic: export chinise data in flat file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 10:00:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.