OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL loader (linux,oracle11g)

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

SQL loader [message #548840]

Mon, 26 March 2012 10:49

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

Report message to a moderator

Re: SQL loader [message #548843 is a reply to message #548840]

Mon, 26 March 2012 11:03

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: SQL loader [message #548846 is a reply to message #548843]

Mon, 26 March 2012 11:58

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: SQL loader [message #549061 is a reply to message #548840]

Tue, 27 March 2012 16:59

Barbara Boehmer
Messages: 9104
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.

Report message to a moderator

Previous Topic:	Unable to use REMAP_TABLE
Next Topic:	SQL loader - import is having issue in new line \n

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:44:02 CST 2025