OraFAQ Forum: Server Utilities » SQL LOADER use two separate field

Home » RDBMS Server » Server Utilities » SQL LOADER use two separate field

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

SQL LOADER use two separate field [message #70797]

Wed, 24 July 2002 08:34

guiguy
Messages: 1
Registered: July 2002

Junior Member

I try to load 2 separate fields of my file into only one field on my table.

Does someone know how to do it ??????

Report message to a moderator

Re: SQL LOADER use two separate field [message #70798 is a reply to message #70797]

Wed, 24 July 2002 09:05

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

Senior Member
Account Moderator

just concat it!
something like

LOAD DATA 
INFILE 'myfile.txt' 
insert
INTO TABLE mytble 
FIELDS TERMINATED BY "," 
TRAILING NULLCOLS 
(col1 CHAR(8), 
col2 CHAR(10), 
col3 CHAR(18) ":col1||' '||:col2")

Report message to a moderator

Previous Topic:	Re: ORA-12560: TNS:Protocol adaptor error while running SVRMGRL
Next Topic:	Re: ORA-12560: TNS:Protocol adaptor error while running SVRMGRL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 12:52:54 CDT 2024