Can I put the name of the file I'm loading in a column via sql loader?
LOAD DATA
APPEND INTO TABLE PFD_FILE
TRAILING NULLCOLS
(
FILENAME char,
FILENAME_CERTIFICATION ,
DATE_CREATE "TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS')"
)
Can I put the name of the file I'm loading in a column via sql loader?
LOAD DATA
APPEND INTO TABLE PFD_FILE
TRAILING NULLCOLS
(
FILENAME char,
FILENAME_CERTIFICATION ,
DATE_CREATE "TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS')"
)