Direct path Insert/Append row count

Say you have a query like this that appears in a PL/SQL block.

INSERT /*+ APPEND */ INTO t1 (SELECT * FROM t2);

How do you tell how many rows were inserted into t1? Obviously I could run a count on the select statement from t2 that appears in the insert, or I could run a count on t1 before and after the insert and find the difference. But SQLPlus reports back the inserted count...surely I can nab that same value from PL/SQL.

Any ideas? Thanks! Received on Fri Mar 07 2003 - 15:28:52 CST