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?
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: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
newcolname "substr(:othercolname,1,4)"
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
)
Previous Topic: Space utilisation for number.
Next Topic: Toad giving ORA-12154:
Goto Forum:
  


Current Time: Thu Dec 08 16:40:48 CST 2016

Total time taken to generate the page: 0.13703 seconds