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: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 14 Mar 2004 08:26:04 +1100
Message-ID: <40537c74$0$3953$afc38c87@news.optusnet.com.au> 






"DJ" <nospamplease_at_goaway.com> wrote in message
news:mSK4c.1217$Yx1.1089_at_newsfe5-



> so what is wrong with select count .... which is always possible and is

what


> the OP wanted




What is wrong with select count? Nothing particularly. Except that the OP
was told that SQL Plus can't suppress results, which it can. And perhaps the
OP might find the other statistics useful, too, given that the entire
original post sounds as though there is some checking or verifying (and
therefore perhaps some tuning) of the SQL statement in question going on.



Regards


HJR

Received on Sat Mar 13 2004 - 15:26:04 CST












Original text of this message













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