Home » RDBMS Server » Server Utilities » sql*loader to skip records (oracle 9i)
sql*loader to skip records [message #413979] Mon, 20 July 2009 00:34 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi experts goodmorning to all of u
How can we load records 2,4,7 from the following flat file Plese help me

sno sname
100 ramesh
200 raj
300 mahesh
400 kamesh
500 rajesh
600 ram
700 shyam
i want to insert only 200 raj
400 kamesh
700 Shyam
How can we do that.
Re: sql*loader to skip records [message #413983 is a reply to message #413979] Mon, 20 July 2009 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is it line 2,4,7 or sno 200,400,700?

Regards
Michel

[Updated on: Mon, 20 July 2009 01:01]

Report message to a moderator

Re: sql*loader to skip records [message #414005 is a reply to message #413979] Mon, 20 July 2009 01:59 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Loading records based on a condition might be what you are looking for.
Re: sql*loader to skip records [message #414026 is a reply to message #413983] Mon, 20 July 2009 02:47 Go to previous messageGo to next message
ramesha
Messages: 6
Registered: July 2009
Junior Member
It's line 2,4,7
Re: sql*loader to skip records [message #414031 is a reply to message #414026] Mon, 20 July 2009 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And why these lines? how to you determine these lines? And what happens to your loading process if someone add or remove one line?

Regards
Michel
Re: sql*loader to skip records [message #414050 is a reply to message #414026] Mon, 20 July 2009 03:55 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ramesha wrote on Mon, 20 July 2009 09:47
It's line 2,4,7

How do you know it's this, you are not OP!

Regards
Michel

Previous Topic: external tables
Next Topic: pls help me out
Goto Forum:
  


Current Time: Fri Mar 29 04:05:07 CDT 2024