Hi ,
i am importing all the text files in a folder into a single table using sqlloader.i need to insert the name of the file that is loaded as a column's value. can anybody help me out. this is the code of the control file that i am using...
options (skip=1)
LOAD DATA
INFILE "FILENAME"
APPEND
INTO TABLE SCOTT.prod
TRAILING NULLCOLS
(
name POSITION(1:10) CHAR TERMINATED BY WHITESPACE,
pid POSITION(20:23) INTEGER EXTERNAL TERMINATED BY WHITESPACE,
pri POSITION(27:27) CHAR TERMINATED BY WHITESPACE,
thd POSITION(30:31) CHAR TERMINATED BY WHITESPACE,
HND POSITION(34:36) CHAR TERMINATED BY WHITESPACE,
PRIV POSITION(39:43) CHAR TERMINATED BY WHITESPACE,
CPUTIME POSITION(49:59) CHAR TERMINATED BY WHITESPACE,
ELAPSDTIME POSITION(63:75) CHAR TERMINATED BY WHITESPACE,
ipaddress constant "FILENAME",
d_date SYSDATE,
time SYSDATE
)
also i need to include time as a column valu.please help me out...
thanks and regards,
jith