Re: Oracle system tables and views

user_tab_columns, all_tab_columns, dba_tab_columns

Next time get familiar with the view "dictionary" / "dict"

Anurag

"Prasad" <psdasari_at_hotmail.com> wrote in message news:605a931c.0301231637.70c5d8b1_at_posting.google.com...
> Hi,
>
> I have created a table in a user schema. as below
>
> Create table test(one number(2),two number(2));
>
> I want to get the details of the above table from the Oracle data
> dictionary. I could verify the all_all_tables view for this tablename.
> I would like to get the colmn information of this table. Is there any
> Oracle system table that maintains the column information of the
> table?.
>
> Any inputs are highle appreciated.
>
> Thanks in advance,
> Prasad
Received on Thu Jan 23 2003 - 19:29:06 CST