Home » RDBMS Server » Server Utilities » SQL loader (linux,oracle11g)
SQL loader [message #548840] Mon, 26 March 2012 10:49 Go to next message
nsumankumar
Messages: 5
Registered: November 2010
Location: banglore
Junior Member

HI

I want to load single column data into multiple columns

can any body please help in this scenario

thanks in advance..

Thanks & Regards
Suman
Re: SQL loader [message #548843 is a reply to message #548840] Mon, 26 March 2012 11:03 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: SQL loader [message #548846 is a reply to message #548843] Mon, 26 March 2012 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 66781
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use BOUNDFILLER and SUBSTR.
See http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_skip_certain_columns_while_loading_data.3F

Regards
Michel
Re: SQL loader [message #549061 is a reply to message #548840] Tue, 27 March 2012 16:59 Go to previous message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
You should be able to use either fixed position or delimiters to determine which goes where. Please post your table structure, sample data, and results you want.
Previous Topic: Unable to use REMAP_TABLE
Next Topic: SQL loader - import is having issue in new line \n
Goto Forum:
  


Current Time: Tue Jan 21 01:44:04 CST 2020