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

Home -> Community -> Usenet -> c.d.o.misc -> Getting record counts using SQL%rowcount

Getting record counts using SQL%rowcount

From: Mike C <michaeljc70_at_hotmail.com>
Date: 3 Oct 2006 13:26:34 -0700
Message-ID: <1159907194.771163.230770@e3g2000cwe.googlegroups.com>


I am trying to run a script in SQL Plus that will execute a bunch of report queries giving the number of rows returned after each one. What I have below (an example) doens't work and Oracle chokes. Why doesn't it like SQL%rowcount?

select 1 from dual; --fake report query

select SQL%rowcount from dual;

select 2 from dual; --fake report query

select SQL%rowcount from dual; Received on Tue Oct 03 2006 - 15:26:34 CDT

Original text of this message

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