Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle system tables and views
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