OraFAQ Forum: Server Utilities » sql*loader to skip records

Home » RDBMS Server » Server Utilities » sql*loader to skip records (oracle 9i)

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

sql*loader to skip records [message #413979]

Mon, 20 July 2009 00:34

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.

Report message to a moderator

Re: sql*loader to skip records [message #413983 is a reply to message #413979]

Mon, 20 July 2009 01:01

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Loading records based on a condition might be what you are looking for.

Report message to a moderator

Re: sql*loader to skip records [message #414026 is a reply to message #413983]

Mon, 20 July 2009 02:47

ramesha
Messages: 6
Registered: July 2009

Junior Member

It's line 2,4,7

Report message to a moderator

Re: sql*loader to skip records [message #414031 is a reply to message #414026]

Mon, 20 July 2009 02:57

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: sql*loader to skip records [message #414050 is a reply to message #414026]

Mon, 20 July 2009 03:55

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 11:21:26 CST 2025