This should be fairly easy for regular users of
Here is my .ctl file:
into table hp_drive_test
fields terminated by ","
(ser_part_id, prod_tag, fru_ser_seq,
fru_bld_dt DATE "DD_MON-YY",
soft_err_tot, tot_def_worst_hd, max_inc_sk_avg,
max_full_sk_avg, avg_sk, npes_nrro, npes_rro,
spinup_time, run_current, row_add_dt ..... problem field)
I want to put the current system date "sysdate" into the
field called row_add_dt. How do I tell sql*load this?
I know I can do this -----> row_add_dt constant "08-JUN-93"
BUT, obviously, i don't want to have to do this everytime I load.
or post to this newsgroup. Thanks!