Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle system tables and views

Oracle system tables and views

From: Prasad <psdasari_at_hotmail.com>
Date: 23 Jan 2003 16:37:23 -0800
Message-ID: <605a931c.0301231637.70c5d8b1@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 - 18:37:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US