OraFAQ Forum: Server Utilities » How to add extended values in control file

Home » RDBMS Server » Server Utilities » How to add extended values in control file (oracle 9i)

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

How to add extended values in control file [message #330198]

Fri, 27 June 2008 21:18

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

Report message to a moderator

Re: How to add extended values in control file [message #330199 is a reply to message #330198]

Fri, 27 June 2008 22:01

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.

Report message to a moderator

Re: How to add extended values in control file [message #330218 is a reply to message #330198]

Sat, 28 June 2008 00:40

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: How to add extended values in control file [message #330246 is a reply to message #330218]

Sat, 28 June 2008 03:23

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

Report message to a moderator

Re: How to add extended values in control file [message #330269 is a reply to message #330246]

Sat, 28 June 2008 09:23

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Previous Topic:	Stored Procs Deployment
Next Topic:	Sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 03:10:54 CDT 2024