Home » SQL & PL/SQL » SQL & PL/SQL » how to delete specific number of records in a table
how to delete specific number of records in a table [message #1562] Mon, 13 May 2002 06:19 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
is there any easy command to delete say 100,000 records by specific number other than setting up a counter in your code?

Report message to a moderator

Re: how to delete specific number of records in a table [message #1564 is a reply to message #1562] Mon, 13 May 2002 09:20 Go to previous message
sfhollands
Messages: 15
Registered: October 2001
Junior Member
use rownum

Report message to a moderator

Previous Topic: Question on EXIT WHEN statement
Next Topic: returning cursors to ado objects from stored procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 14:11:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.