Re: limit rowcount

From: Michel Cadot <micadot_at_altern.org>
Date: Thu, 5 Aug 1999 14:20:14 +0200
Message-ID: <7obvj2$aa$1@oceanite.cybercable.fr>

Try this

delete from tableXXXX where rownum <= 100;

It works fine.

Norris a écrit dans le message <7obnv5$761$1_at_imsp009a.netvigator.com>...
>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.
>
>--
>===================================
>http://www.washington.edu/pine/faq/
Received on Thu Aug 05 1999 - 07:20:14 CDT