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

larroyo114_at_yahoo.com (Lara) wrote in message news:<73447077.0403130816.3bf4ae67_at_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!

What I usually do is to put the original query in an inline view and do a count(*) on it, e.g:

select count(*) from (
Select student_id from student
);

TW Received on Sun Mar 14 2004 - 15:01:53 CST