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]