OraFAQ Forum: Server Utilities » SQL*LOADER-how to load the infile name to field?

Home » RDBMS Server » Server Utilities » SQL*LOADER-how to load the infile name to field?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*LOADER-how to load the infile name to field? [message #163827]

Mon, 20 March 2006 04:59

orbsun
Messages: 1
Registered: March 2006

Junior Member

I need to record the data file name to field when I use sqlldr.

in control file:
LOAD DATA
APPEND
INTO test
(
filename "SUBSTR('\DATA\', INSTR('\DATA\','/', -1, 1)+1)"
)

but failed.

Thanks for advice.

Report message to a moderator

Re: SQL*LOADER-how to load the infile name to field? [message #163833 is a reply to message #163827]

Mon, 20 March 2006 05:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please see whether this helps
http://www.orafaq.com/forum/t/12234/0/

Report message to a moderator

Previous Topic:	concatenate string to column while loading
Next Topic:	need help with exp/imp plz!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 19:27:17 CDT 2024