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 -> Re: Any way to get FEEDBACK on an Anonymous Block?

Re: Any way to get FEEDBACK on an Anonymous Block?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jan 2007 09:22:28 -0800
Message-ID: <1168104148.547008.326220@q40g2000cwq.googlegroups.com>

sybrandb wrote:
> Mike C wrote:
> > Is there anyway to get automatic FEEDBACK (like 8 rows updated, etc.)
> > on commands in an Anonymous block in a SQL*Plus script?
>
> SQL%ROWCOUNT has the number of records selected or updated, or inserted
> or deleted.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Mike, %ROWCOUNT is known as a cursor attribute. Look this term up in the index of your PL/SQL User Guide and Reference for others and for finding details on using them.

HTH -- Mark D Powell -- Received on Sat Jan 06 2007 - 11:22:28 CST

Original text of this message

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