Re: Display table columns

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 01 Jul 2004 23:26:59 GMT
Message-ID: <751Fc.63359$E84.34473@edtnps89>

xo55ox wrote:

> Hi,
>
> I like to know beside using 'desc table_name' statement to show
> columns, is there any other way to retrieve table's column? Is there
> any system tables that store other tables' (user tables') columns?
>
> Thanks in advance.

Oracle has a cute little book they include in their documentation at http://docs.oracle.com, called "Reference". It includes all the init.ora parameter and all the dictionary tables.

Look at chapter 2 of
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm Received on Thu Jul 01 2004 - 18:26:59 CDT