Lara wrote:
> 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!
Can you run the results into a temp table and do a count(*) from the
temp table?
Received on Wed Mar 17 2004 - 14:03:16 CST
