Re: how to see the complete description of table in oracle
From: gazzag <gareth_at_jamms.org>
Date: Wed, 18 Feb 2009 04:39:40 -0800 (PST)
Message-ID: <fa2121fa-a71a-4a39-b446-1b23a3b4d0a8_at_v15g2000yqn.googlegroups.com>
On 18 Feb, 08:52, juned2..._at_gmail.com wrote:
> hi,
> i want to see the complete description of table with it's structure
> and constraints.
> I also want to see the column name on which the constraints are
> applied.
Date: Wed, 18 Feb 2009 04:39:40 -0800 (PST)
Message-ID: <fa2121fa-a71a-4a39-b446-1b23a3b4d0a8_at_v15g2000yqn.googlegroups.com>
On 18 Feb, 08:52, juned2..._at_gmail.com wrote:
> hi,
> i want to see the complete description of table with it's structure
> and constraints.
> I also want to see the column name on which the constraints are
> applied.
Depending on Oracle version, check out the DBMS_METADATA package.
Example: http://www.psoug.org/reference/dbms_metadata.html
HTH -g Received on Wed Feb 18 2009 - 06:39:40 CST