sqlldr sql Loader oracle insert file name in a column

Asked

Viewed 75 times

2

I can put the name of the file I am 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')"
)
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.