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

From: Martin Mølskov Hansen <mmh_at_kab-bolig.dk>
Date: Sun, 14 Mar 2004 16:27:48 +0100
Message-ID: <4054787e$0$1595$edfadb0f@dread14.news.tele.dk>

Hmm, forgotten about that one, sorry.

Regards
Martin M. Hansen

"Howard J. Rogers" <hjr_at_dizwell.com> skrev i en meddelelse 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
>
>
Received on Sun Mar 14 2004 - 09:27:48 CST