Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> limit rowcount

limit rowcount

From: Norris <johnnie_at_cooper.com.hk>
Date: 5 Aug 1999 10:10:45 GMT
Message-ID: <7obnv5$761$1@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 - 05:10:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US