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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlplus question

Re: sqlplus question

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 17 Oct 2006 17:26:19 +0100
Message-ID: <be592d550610170926h67ab13cdtd2df01f0ec0096f9@mail.gmail.com>


no, beucase count(*) is just a simple count - you woul dbe asking the database to give you something different.

You must code that if you want it with a group by

On 17/10/06, John Dunn <jdunn_at_sefas.com> wrote:

>

> Is there a quick way to configure sqlplus so that when I do
> select(*) from mytable I get one line for each column name/value pair?
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 17 2006 - 11:26:19 CDT

Original text of this message

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