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

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL and ROWNUM

PL/SQL and ROWNUM

From: Peter Jones <pete_at_pkjones0.demon.co.uk>
Date: Tue, 16 Feb 1999 18:47:05 -0000
Message-ID: <919189969.5911.0.nnrp-13.9e98fc27@news.demon.co.uk>


Is there an efficient way of restricting the number of rows removed by a delete statement to a given number from within a PL/SQL block?

I'm currently using ROWNUM to achieve this. Is it efficient, or is there a better way?

Thanks in advance
Pete Received on Tue Feb 16 1999 - 12:47:05 CST

Original text of this message

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