Printable View
If I am loading a datafile using SQL*LOADER and I want to default a column to the date the record was loaded can this be done without setting the defaults of the table? How do I specify this in the control file?
datafile ex.
abcdefgh
table abc
col1 col2 col3
abcd 12-JAN-01 efgh
[Edited by FRANK on 01-12-2001 at 11:44 AM]
Your control file would be something like this;
LOAD DATA
APPEND
INTO /TABLE NAME/
COL1 abcd
COL2 sysdate
COL3 efgh
sysdate will populate your column correctly.
You can include SQL code in your ctl file. You would assign
SYSDATE to the column - Check the server utilities guide for your version of Oracle - Sqlloader (Applying SQL operators to fields).
Post your ctl file if you still have problems.