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?