Re: check how many rows processed of a sql statement

Thanks Tom, I was actually wondering whether it is possible to check before a long-running sql statement get finished, that how many rows has been processed, which gives me an idea about how far is the job. Is this possible?

David

On Mon, 06 Jul 1998 14:09:16 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>A copy of this was sent to dshi_at_magpage.com (David Shi)
>(if that email address didn't require changing)
>On 6 Jul 1998 01:07:27 GMT, you wrote:
>
>>Is there a way to check how many rows processed of a sql statement? Thanks.
>>
>>David
>
>depends on the language.
>
>In C and Pro*C sqlca.sqlerrd[2] has it.
>
>In PL/SQL with 'static' sql, sql%rowcount after an insert/update/delete has it.
>
>In PL/SQL with 'dynamic' sql, dbms_sql.execute returns it as a value...
>
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>http://govt.us.oracle.com/ -- downloadable utilities
>
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
Received on Mon Jul 06 1998 - 18:45:41 CDT