Home » RDBMS Server » Server Utilities » How to populate one column based on another columns data?
How to populate one column based on another columns data? [message #244459] Wed, 13 June 2007 00:35 Go to next message
jvnaveen
Messages: 29
Registered: March 2005
Location: Bangalore
Junior Member
Hi Friends,

I'm using SQL*Loader for loading data from csv to a table. In the csv file, I have a column called Indicator which contais 1 for some rows. while loading onto my table, I have to get update a new column based on Indicator column.

Ex:

If Indicator in the csv is 1 then the table column tmp should be updated with 'C'

How to do this? Please give me the syntax

Thanks
Naveen J V

Report message to a moderator

Re: How to populate one column based on another columns data? [message #244467 is a reply to message #244459] Wed, 13 June 2007 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Even if you can do it with SQL*Loader, use external table instead.
It is easier and faster.

Regards
Michel

Report message to a moderator

Re: How to populate one column based on another columns data? [message #244596 is a reply to message #244459] Wed, 13 June 2007 08:29 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Here is a hint:

"decode(:indicator,1,'C',null)"

Report message to a moderator

Previous Topic: Problem in Import
Next Topic: Problem SQL Loading a delimited file into two different tables? Please Help!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 08:07:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.