[OT] Re: [ILUG] Oracle question

[Darragh]

It’s at the sql level. 

Thanks



Darragh Ó Héiligh
Web development, O/S and Application technical support.
   Website:	http://www.digitaldarragh.com

-----Original Message-----
From: Nick Murtagh [mailto:nickm at go2.ie] 
Sent: 26 May 2006 14:22
To: Darragh
Cc: 'Irish Linux Users Group'
Subject: [OT] Re: [ILUG] Oracle question

Darragh wrote:
> I need to display the result of a select statement horizontly instead of
> verticly.

At what level, the SQL level? It would surely be trivial to do this
in your application.

You could always do two selects:

     select ID from table where ID = 1;
     select Number from table where ID = 1;

Kinda nasty though. And you would probably want to do that inside a
transaction as well.