ALSO
select * from mytablee
where 1=2;
"Lee Crampton" <lee_at_avbrief.com> wrote in message
news:lYgK7.12484$tm3.1786101_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 - 21:03:00 CST
