Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question: SQL*Plus command to see number of query result rows

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

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 13 Mar 2004 18:45:19 -0000
Message-ID: <jEI4c.410$nN6.135@newsfe1-win>

"Lara" <larroyo114_at_yahoo.com> 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!

of course you can do count.. Received on Sat Mar 13 2004 - 12:45:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US