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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find no of rows

Re: How to find no of rows

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Wed, 11 Sep 2002 02:33:40 GMT
Message-ID: <3D7EAB1B.AC2F5237@mailhost.det.ameritech.net>

"M.Balaji" wrote:
>
> Hi All,
> When i run a SQL statement, to find out the no of rows processed and
> no of times the SQL statement as executed i use the following query.
>
> set echo off
> set feedback off
> set heading off
> set line 100
>
> select '----------------------- '|| chr(10),
> 'Session Id : ' || b.sid || ' Serial# ' || b.serial#
> || chr(10) ||
> 'Username : ' ||
> decode(b.username,NULL,'System',b.username) || chr(10) ||
> 'Rows Processed : ' || a.rows_processed || chr(10) ||
> 'Executions : ' || a.executions || chr(10) ||
> 'Sql Statement : ' || a.sql_text || chr(10)
> from v$sql a , v$session b
> where a.hash_value = b.sql_hash_value and b.status = 'ACTIVE' and
> (b.username is not null and b.username <> 'SYS')
> /
>
> For the following SQL statement,with the above query, i canno see how
> many rows
> processed
>
> insert into table_a select * from table_b;
>
> Anyone aware of how to get the no of rows processed. Please help me
> out.
>
> Thanks and Regards
> M.Balaji

I believe you want SQL%ROWCOUNT

-- 
Andrew Allen
Livonia, MI
E- Mailto:ajalle_at_ameritech.net
Received on Tue Sep 10 2002 - 21:33:40 CDT

Original text of this message

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