Re: Data dictionary name

user_tab_columns for your own tables
all_tab_columns for all the tables you have access to dba_tab_columns for all tables in the database.

Hth,
Sybrand Bakker, Oracle DBA

Jaco Van Rooyen <jaco_at_ctru.auckland.ac.nz> wrote in message news:37a51b0e.25709288_at_news.auckland.ac.nz...
> Hi,
>
> Bit of a newby question.
>
> I'd like to find a data dictionary I can query to get the columns
> associated with a particular table. Something like the following:
>
> SELECT
> column_name
> FROM
> blah
> WHERE
> table_name like '%qwerty%';
>
> Anybody know the name of blah.
>
> Thanks,
> Jaco
Received on Mon Aug 02 1999 - 00:14:08 CDT