Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get "number_of_affected_rows" after "insert ... select..."
Use SQL%ROWCOUNT
Hth,
--
Sybrand Bakker, Oracle DBA
<gmei_at_my-deja.com> wrote in message news:7vvgha$8mi$1_at_nnrp1.deja.com...
> Hi:
>
> I have a procedure in an oracle package which does something like
>
> insert into table1
> (col1,
> col2)
> select
> val1,
> val2
> from tableA
> where tableA.colA = 'something';
>
> This can insert more than one rows in table1, I want to know how many
> rows inserted in table1 without doing another "select count(*) .." query
> so I can determine if the sql runs successfully.
>
> Is there a "global" variable in oracle which will return the
> "number_of_affected_rows" after an executed sql statement?
>
> I am not using dynamic sql and I thought "RETURNING" clause only can
> return single row.
>
> Any suggestions?
>
> Thanks.
>
> Guang
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 05 1999 - 16:38:19 CST