OraFAQ Forum: Server Utilities » How to load substr via sql loader

Home » RDBMS Server » Server Utilities » How to load substr via sql loader

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

How to load substr via sql loader [message #196485]

Thu, 05 October 2006 09:43

catpurr
Messages: 11
Registered: November 2005

Junior Member

I need to load flat file via SQL loader. while loading data, I need to load extra column from a existing column substr. How can I sepecify this in control file?

Report message to a moderator

Re: How to load substr via sql loader [message #196519 is a reply to message #196485]

Thu, 05 October 2006 13:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

newcolname "substr(:othercolname,1,4)"

Report message to a moderator

Re: How to load substr via sql loader [message #199584 is a reply to message #196485]

Wed, 25 October 2006 03:37

frank.svs
Messages: 162
Registered: February 2006

Senior Member

The control file with functions would look like below :

load data infile 'data.csv'
append into table sample
fields terminated by ","
(
id,
name "substr(:name,1,3)",
sal
)

Report message to a moderator

Previous Topic:	Space utilisation for number.
Next Topic:	Toad giving ORA-12154:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 28 13:33:43 CST 2025