RE: sqlplus question

  • From: "John Dunn" <jdunn@xxxxxxxxx>
  • To: "'David Sharples'" <davidsharples@xxxxxxxxx>
  • Date: Wed, 18 Oct 2006 07:21:59 +0100

Apologies I meant to say select * from mytable
  -----Original Message-----
  From: David Sharples [mailto:davidsharples@xxxxxxxxx]
  Sent: Tuesday, October 17, 2006 5:26 PM
  To: jdunn@xxxxxxxxx
  Cc: oracle-l@xxxxxxxxxxxxx
  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@xxxxxxxxx> 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?

Other related posts: