Row count [message #10220] |
Fri, 09 January 2004 00:06 |
Patrick Tahiri
Messages: 119 Registered: January 2004
|
Senior Member |
|
|
Hi,
Is there a sort of "rowcount" Oracle system variable that a PLSQL developer could use? Does a such Oracle parameter exist?
I would like to retreive this information inside a declared variable (in a stored procedure) after a select statment. Thus I can store in my variable how much rows have been retreived by this select statment.
Something like:
SELECT ...
FROM table_name
WHERE ...
SELECT v_variable = row_count_system_parameter
So, v_variable will store the number of rows retreived by my select statment.
Many thanks for your answers.
Regards,
Patrick.
|
|
|
|
Re: Row count [message #10230 is a reply to message #10220] |
Fri, 09 January 2004 03:20 |
resy
Messages: 86 Registered: December 2003
|
Member |
|
|
just see this.
declare
sname1 supplier.sname%type;
cnt integer;
cursor c1 is
select sname
from supplier;
begin
open c1;
loop
fetch c1 into sname1;
exit when c1%notfound;
end loop;
cnt := c1%rowcount;
dbms_output.put_line('No of rows selected:'||cnt);
end;
SQL> /
No of rows selected:11
PL/SQL procedure successfully completed.
|
|
|