Newbie question: SQL*Plus command to see number of query result rows

From: Lara <larroyo114_at_yahoo.com>
Date: 13 Mar 2004 08:16:51 -0800
Message-ID: <73447077.0403130816.3bf4ae67@posting.google.com>

Hi, I have what I think is a simple SQL*Plus question, but I can't find the answer in any of my books.

I'm trying to turn off SQL*Plus displaying the result of each row in a select statement, and just want to see the number of rows the select statement would generate. I'm trying to see if my select statement is correctly generating the correct number of rows. I know it should generate 154,280 rows, but it takes too long to sit here and wait to see the results if every row of the query result displays.

In other words (in a shortened example), I currently have:

SQL> Select student_id from student;

STUDENT_ID

---

       391
       392
       393

3 rows selected.

Is there any command I can use to get:
SQL> Select student_id from student;

3 rows selected.

p.s. I don't think I can use COUNT because there are multiple joins and subqueries throughout the select.

Thanks! Received on Sat Mar 13 2004 - 10:16:51 CST