RE: sqlplus question

From: John Dunn <jdunn_at_sefas.com>
Date: Wed, 18 Oct 2006 07:21:59 +0100
Message-ID: <00b701c6f27d$b890a9c0$3e04050a@johnman>

Apologies I meant to say select * from mytable   -----Original Message-----
  From: David Sharples [mailto:davidsharples_at_gmail.com]   Sent: Tuesday, October 17, 2006 5:26 PM   To: jdunn_at_sefas.com
  Cc: oracle-l_at_freelists.org
  Subject: Re: sqlplus question

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 Wed Oct 18 2006 - 01:21:59 CDT