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

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 13 Mar 2004 21:38:02 -0000
Message-ID: <xaL4c.1427$Yx1.553@newsfe5-gui.server.ntli.net>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40537c74$0$3953$afc38c87_at_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
>
>

ok, fair point - ill go with that :-) Received on Sat Mar 13 2004 - 15:38:02 CST