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 -> Re: How many rows were updated ?

Re: How many rows were updated ?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 27 Jul 1999 23:28:21 +0200
Message-ID: <933110891.4654.0.pluto.d4ee154e@news.demon.nl>


Hi Vincent,
Assuming you are using implicit cursors, you can use SQL%ROWCOUNT to get these results.

Hth,

Sybrand Bakker, Oracle DBA

Vincent GRENET <vincent.grenet_at_free.fr> wrote in message news:z_on3.53$nd4.307221_at_nnrp1.proxad.net...
> Hi all.
>
> In an stored procedure, how can I know how many rows were updated by an
> update statement ? I've seen in the PRO*C precompiler documentation that I
> can find that information in the sqlca area. But I did not see anything
like
> that in the SQL or PL/SQL documentation.
>
> Or can I know if any row was updated ? Same question for a delete.
>
> Vincent
>
>
>
>
>
Received on Tue Jul 27 1999 - 16:28:21 CDT

Original text of this message

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