Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning column names is a select statement

Re: Returning column names is a select statement

From: <jeanch_at_my-deja.com>
Date: Mon, 13 Mar 2000 09:52:52 GMT
Message-ID: <8aidpk$fuj$1@nnrp1.deja.com>


In article <k5Ry4.2476$A4.150473_at_c01read04.service.talkway.com>,   "dredogg" <dredogg_at_bell.net> wrote:
> How can I return column names in a select statement?
>
> Thanks in advance.
> --
> Free audio & video emails, greeting cards and forums
> Talkway - http://www.talkway.com - Talk more ways (sm)
>
>

Not sure I understood your question but you can try this if you will
Select column_name from all_tab_columns where owner = 'SCOTT'
and table_name = 'EMP'

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 13 2000 - 03:52:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US