Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning column names is a select statement
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
![]() |
![]() |