Re: how many rows did I just insert?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 20 Aug 1999 19:13:05 +0200
Message-ID: <935169209.16592.0.pluto.d4ee154e@news.demon.nl>

Hi Ken,

The result for INSERTs, UPDATEs, DELETEs is in SQL%ROWCOUNT.

What makes you believe there is a better group?

Hth,

Sybrand Bakker, Oracle DBA

KTL <ktl_at_rs-net.com> wrote in message news:37BD7458.EFE51A01_at_rs-net.com...
> In a procedure I have a insert into ...selcet as ...statement..
> how can I tell how many rows I just inserted? Is there a way to use
> ..RETURNING to get this?
>
> suggestions?
>
> Also, is there a better group to be asking Oracle PL/SQL questions in?
>
> Thanks....
>
> -Ken
>
Received on Fri Aug 20 1999 - 12:13:05 CDT