Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Any way to get FEEDBACK on an Anonymous Block?
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
![]() |
![]() |