SQL*Plus and Feedback (xx Rows Selected) Line

From: absinth <absinth_at_gmail.com>
Date: 22 May 2005 16:59:24 -0700
Message-ID: <1116806364.144092.194130@o13g2000cwo.googlegroups.com>

Hi,

Consider the following SQL*Plus:

SQL> select row_id from CX_LOCK;

ROW_ID

---

1
2
3
4
5
6
7
8
9
10
11

ROW_ID

---

12

12 rows selected.

Is there a way to return the '12' rows selected in an SQL*Plus variable or soemthing similar without doing another count?

I'm attempting to run a select statement (a complex one) that generates a report but sometimes it takes so long to execute that it selects out of an older snapshot of the database and returns less rows than expected. I want to somehow save this number then run exactly the same select but with a count(1) instead of column definitions and compare the two numbers.

Any suggestions? Received on Sun May 22 2005 - 18:59:24 CDT