Re: How many records do I commit after insert?

Violin (what a nice name)

you can either use SQL%ROWCOUNT to capture the affected number of rows

thanks
howard

Violin wrote:

> 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 Thu Oct 08 1998 - 20:42:55 CDT