OraFAQ Forum: Server Utilities » Issue with SQL LOADER Control file [merged two by jd]

Home » RDBMS Server » Server Utilities » Issue with SQL LOADER Control file [merged two by jd]

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

Issue with SQL LOADER Control file [merged two by jd] [message #668868]

Tue, 20 March 2018 02:33

sp_siva
Messages: 3
Registered: March 2018

Junior Member

I have a issue with SQL Control file

Here is my feed file which I am trying to load into oracle table using sqlldr
No|Name|ID|Location|value
12|simple||Singapore|gold
34|barate|TEST|London|siler
45|sdfsdfs||America|diamond

Now the requirement on the column 3 (ID)
Option#1 ==> if the column3 (ID) is empty and then we can update the oracle sequence number --> its working with with below codes
ID "Sequence.NEXTVAL",

Option#2 ==> if the column3 (ID) is having some values for few records and then we can skip the values and update the oracle sequence number --> its not working

The output would be like this, where 123,124,125 is the sequence no Mad

45|sdfsdfs|125|America|diamond

Kindly help me out on this.

Report message to a moderator

[Message index]

		Issue with SQL LOADER Control file [merged two by jd] By: sp_siva on Tue, 20 March 2018 02:33
		how to add tow condition on SQL loader control file column By: sp_siva on Tue, 20 March 2018 02:46
		Re: Issue with SQL LOADER Control file By: joy_division on Tue, 20 March 2018 08:03
		Re: Issue with SQL LOADER Control file By: joy_division on Tue, 20 March 2018 08:10
		Re: Issue with SQL LOADER Control file By: sp_siva on Thu, 22 March 2018 23:25
		Re: Issue with SQL LOADER Control file By: Barbara Boehmer on Fri, 23 March 2018 13:59

Previous Topic:	SQL*Loader-350: Syntax error at line 9. Expecting "(" WHEN clause
Next Topic:	Moving entire DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 13:36:55 CDT 2024