Re: Getting record counts using SQL%rowcount

From: K. Nielsen <nahdsl232734_at_nahvip.cybercity.dk>
Date: Tue, 3 Oct 2006 23:09:45 +0200
Message-ID: <4522d19a$0$140$157c6196@dreader2.cybercity.dk>

"Mike C" <michaeljc70_at_hotmail.com> wrote in message news:1159907194.771163.230770_at_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;
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:6128764893231775683::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1271200549722

tahiti.oracle.com

google

etc. etc. Received on Tue Oct 03 2006 - 16:09:45 CDT