Home » SQL & PL/SQL » SQL & PL/SQL » Row count
Row count [message #10220] Fri, 09 January 2004 00:06 Go to next message
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 #10225 is a reply to message #10220] Fri, 09 January 2004 00:48 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try SQL%ROWCOUNT:
SQL> select count(*)
  2    from emp;

  COUNT(*)
----------
        14

SQL> set serverout on

SQL> begin
  2    update emp set ename = ename;
  3    dbms_output.put_line(SQL%ROWCOUNT||'  records updated');
  4  end;
  5  /
14  records updated

PL/SQL procedure successfully completed.


MHE
Re: Row count [message #10230 is a reply to message #10220] Fri, 09 January 2004 03:20 Go to previous message
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.
Previous Topic: solution please
Next Topic: Stored Procedures & SELECT statement.
Goto Forum:
  


Current Time: Fri Mar 29 02:09:38 CDT 2024