So basic - how do I get column names?

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 - 17:50:46 CST