Home » RDBMS Server » Server Utilities » How to add extended values in control file (oracle 9i)
How to add extended values in control file [message #330198] Fri, 27 June 2008 21:18 Go to next message
deviji
Messages: 23
Registered: November 2007
Junior Member
Dear Techies,

I hava a doubt like,
I have a flat file and i want to upload that using sqlldr to Oracle 9i.

If the value of flat file on one column is say 'SEL' then it should be loaded into the destination file like 'SELECTION'

What kind of changes i should do in control file?

Thanks in advance,

regards
viji
Re: How to add extended values in control file [message #330199 is a reply to message #330198] Fri, 27 June 2008 22:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What kind of changes i should do in control file?
It would be much simpler if you loaded the data as it exists,
& after the completes just UPDATE the column to desired value.
Re: How to add extended values in control file [message #330218 is a reply to message #330198] Sat, 28 June 2008 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
If the value of flat file on one column is say 'SEL' then it should be loaded into the destination file like 'SELECTION'

SQL*Loader does not load into a file, it loads into a table.
What do you want to do?

Post a example.

Regards
Michel
Re: How to add extended values in control file [message #330246 is a reply to message #330218] Sat, 28 June 2008 03:23 Go to previous messageGo to next message
deviji
Messages: 23
Registered: November 2007
Junior Member
Thanks Michel,

If the value of flat file on one column is say 'SEL' then it should be loaded into the destination table like 'SELECTION'

like flat file

200,SEL,RET

I need table like

200 SELECTION RETENSION



regards
viji
Re: How to add extended values in control file [message #330269 is a reply to message #330246] Sat, 28 June 2008 09:23 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If I understand you, if the value is SEL then you want to insert SELECTION in the table; if the value is RET you want to insert RETENSION.
What do you want for other values?
You can use DECODE function in your control file.

Regards
Michel
Previous Topic: Stored Procs Deployment
Next Topic: Sql loader
Goto Forum:
  


Current Time: Tue Dec 24 11:00:20 CST 2024