Re: How many records do I commit after insert?

If this is within PL/SQL, I believe you can interrogate the cursor variables of the implicit cursor, "SQL".
Thus, you could say:

tot := 0;
insert into....
tot := tot + SQL%ROWCOUNT;
insert into....
tot := tot + SQL%ROWCOUNT;
insert into....
tot := tot + SQL%ROWCOUNT;
etc.

Violin wrote in message <361f1eb0.7936353_at_news.twsc.pouchen.com.tw>...
>Hello,
>Does any way to know how many records after insert and commit?
>Ex.
> insert into table1 (col1,col2,col3) (select * from table2);
> insert into table1 (col1,col2,col3) (select * from table3);
> insert into table1 (col1,col2,col3) (select * from table4);
> commit;
>
>I want to know how many records I will commit.
>Please give me some tips.
>Thank you in advance.
>
>Violin.
>violin.hsiao_at_mail.pouchen.com.tw
Received on Fri Oct 09 1998 - 03:17:47 CDT