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