Re: Q: Query, name of columns

From: <michael_bialik_at_my-deja.com>
Date: Sat, 24 Jul 1999 17:14:55 GMT
Message-ID: <7ncsa9$fir$1@nnrp1.deja.com>

Hi.

If you are table's owner :

    DESC <table_name> or
    SELECT column_name FROM USER_TAB_COLUMNS     WHERE table_name = <your_table_name> else
   SELECT column_name FROM ALL_TAB_COLUMNS     WHERE table_name = <your_table_name> and     OWNER = <table_owner>

Michael.

In article <37986420.7C62_at_NOSPAM.se>,
Henrik Otto <ottoh_at_NOSPAM.se> wrote:
> How can I get the names of the columns of a table?
>
> Thanks.
>
> /Henrik
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 24 1999 - 12:14:55 CDT