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

Home -> Community -> Usenet -> c.d.o.tools -> Re: viewing table

Re: viewing table

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Thu, 14 Sep 2000 12:13:25 +0200
Message-ID: <uJgCOSjHAHA.281@net025s>

Arthur,

the information you want is located in different data dictionary views like:

dba_constraints
dba_tables
dba_indexes etc...

if you have a tool like PL/SQL Developer it would make life a whole lot easier.

Arthur <mechhunter_at_rocketmail.com> wrote in message news:39c06d03.21914918_at_news.iinet.net.au...
> Hi all,
>
> This may be a silly question and all but,
> how do you look at the FULL nature of a table -
> what I mean is:
> it will show the contraints within the table,
> the allocated name,
> etc etc.
>
> Thanks -
> -Arthur
Received on Thu Sep 14 2000 - 05:13:25 CDT

Original text of this message

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