Re: Query, name of columns

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Fri, 23 Jul 1999 09:28:12 -0400
Message-ID: <7n9qme$hog$1@msunews.cl.msu.edu>

desc <table>

select column_name from all_tab_columns where table_name = '<table>'

The table all_tab_columns, when combined with dynamic SQL, can support some very useful analysis scripts/procedures.

Chris Weiss
Professional Services Division
Compuware Corporation

Henrik Otto <ottoh_at_NOSPAM.se> wrote in message news:37986420.7C62_at_NOSPAM.se...
> How can I get the names of the columns of a table?
>
> Thanks.
>
> /Henrik
Received on Fri Jul 23 1999 - 08:28:12 CDT