Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How many records do I commit after insert?

How many records do I commit after insert?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Thu, 08 Oct 1998 02:25:38 GMT
Message-ID: <3621229c.8940447@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 Wed Oct 07 1998 - 21:25:38 CDT

Original text of this message

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