How to get column names?

[lakshmivaragan]

Hi,
I understand that column names of table can be got from "cols" or "col" system table.
If I login as "system", I want to get the column names of table which belong to particular user/schema.
In the "cols" or "col" system table, there is no column for schema. How can I get column names of table of particular schema when I login as "system" ?

Regs
Lax

 

[SantaMufasa]

Lax,

select column_id,column_name
from dba_tab_columns
where owner = 'UPPER-CASE SCHEMA NAME'
and table_name = 'UPPER-CASE TABLE NAME'
order by column_id;

You can also run code, above, from ALL_TAB_COLUMNS.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:12 (31Dec03) GMT, 23:12 (30Dec03) Mountain Time)