Re: limit rowcount

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 05 Aug 1999 12:06:04 GMT
Message-ID: <37aa7e13.880696@newshost.us.oracle.com>

A copy of this was sent to Norris <johnnie_at_cooper.com.hk> (if that email address didn't require changing) On 5 Aug 1999 10:10:45 GMT, you wrote:

>Is it possible to limit the number of rows processing of SQL statement in
>oracle? e.g.
>set rowcount 100
>delete from TABLExxx
>
>Then only 100 records are deleted.

delete from tablexxxx
where <your own predicate>
and rownum <= 100;

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Aug 05 1999 - 07:06:04 CDT