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 -> So basic - how do I get column names?

So basic - how do I get column names?

From: Lee Crampton <lee_at_avbrief.com>
Date: Mon, 19 Nov 2001 23:49:12 -0000
Message-ID: <lYgK7.12484$tm3.1786101@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 - 17:49:12 CST

Original text of this message

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