Re: Direct path Insert/Append row count

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 07 Mar 2003 22:47:59 +0100
Message-ID: <or4i6vsejm610j5182hhng6k3cquseta8p@4ax.com>

On 7 Mar 2003 13:28:52 -0800, craig.nelson_at_transplace.com (hbar) wrote:

>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!

Yes. Read up on SQL%ROWCOUNT in your pl/sql manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 07 2003 - 15:47:59 CST