Re: So basic - how do I get column names?

select * from mytable where rownum = 1;

or desc mytable

"Lee Crampton" <lee_at_avbrief.com> wrote in message news:mYgK7.12485$tm3.1785524_at_news11-gui.server.ntli.net...
> Hi all
>
> Ordinarily something like "select * from mytable where false;" would
return
> column headings (no rows).
> This doesn't work in Oracle8i and I cannot for the life of me find either:
> a) the way to return just headings (tried column heading on, col * on etc)
> b) an alternative way to retrieve column names
> Any help gratefully received
> Lee
>
>
>
>
Received on Mon Nov 19 2001 - 18:28:50 CST