Home » RDBMS Server » Server Utilities » How to load substr via sql loader
How to load substr via sql loader [message #196485] Thu, 05 October 2006 09:43 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 14:03:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.