Home » SQL & PL/SQL » 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
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: 4502
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
Previous Topic: SET ECHO OFF does not work
Next Topic: export chinise data in flat file
Goto Forum:
  


Current Time: Sun Dec 04 18:58:38 CST 2016

Total time taken to generate the page: 0.12890 seconds