Re: table's column names

On Nov 27, 3:54 pm, Filipe David Borba Manana <fdman..._at_cern.ch> wrote:
> Greetings!
>
> How can I discover the name of all the columns for each table defined by
> a user?
> Is there any system table which I can query for that purpose?
>
> many thanks

Adding to the reply of Charles Hooper:
The table DICT will show you all tables in the dictionary. You can query it as any other table.
So select * from dict where table_name like '%COL%' would have provided you with the answer.

-- 
Sybrand Bakker
Senior Oracle DBA