[OT] Re: [ILUG] Oracle question

[Paschal Nee]

>It's at the sql level.

I don't think this is done at the SQL level - I think SQL works in rows and
columns and is fairly set in its ways (old age).

So are you taking about the client itself.  For example running the mysql
client with the --vertical attribute

mysql --vertical -u root -p

will get the data coming out like this


*************************** 48. row ***************************
             phone1: 888888
             phone2:888888
               fax1:888888
               fax2:888888
             email1:888888
             email2:888888
*************************** 49. row ***************************
             phone1: 888888
             phone2:888888
               fax1:888888
               fax2:888888
             email1:888888
             email2:888888

Is that what you are looking for?  Are you trying to get TOAD (or whatever
application you use to query your database) to do this?  It should be a
parameter on that application then.

If you're taking about your own home grown application displaying the data
in columns then it's pretty trivial (when you know how I guess) depending on
the API you use?

Thanks,
Paschal.

---------- Forwarded message ----------
From: "Darragh" <lists at digitaldarragh.com>
To: "'Nick Murtagh'" <nickm at go2.ie>
Date: Fri, 26 May 2006 14:33:10 +0100
Subject: RE: [OT] Re: [ILUG] Oracle question
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