Re: sql loader

  • From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
  • To: Brian.Zelli@xxxxxxxxxxxxxxx
  • Date: Tue, 30 Mar 2010 13:49:42 -0400

Brian,
Yes, you are right.

Example:
create table test(col1 number, col2 date);

cat test.dat
1
2
3
4
5

cat test.ctl
load data
infile 'test.dat'
badfile 'test.bad'
discardfile 'test.dsc'

into table TEST
insert
fields terminated by ','
(COL1,
COL2 SYSDATE)

Alisher Yuldashev
Senior Oracle DBA
www.pythian.com

Zelli, Brian wrote:
Ok, I've gone completely brain-dead. I need to add a date column to my sqlload control file, I just use sysdate correct? If it's not part of my input file that's ok right? As long as I have a column named for it on the table I'm loading? Brian

Other related posts: