QUEATION ABOUT SQLLOADER

[FRANK]

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]

[mary]

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.

[Mark_Woz]

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.