From: matthew taylor <s176226@student.uq.edu.au>
Subject: Finding constraints in existing database
Date: 2000/03/03
Message-ID: <38BF684D.2E8C1A6C@student.uq.edu.au>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: news@uq.edu.au
X-Trace: bunyip.cc.uq.edu.au 952067859 29167 172.20.153.222 (3 Mar 2000 07:17:39 GMT)
Organization: University of Queensland
Mime-Version: 1.0
NNTP-Posting-Date: 3 Mar 2000 07:17:39 GMT
Newsgroups: comp.databases.oracle.misc


a while ago i discovered 
select * from USER_TABLES;

and the resulting flood of information when filtered yielded all kinds
of interesting information.... like all the names of tables in the table
space etc.

I'm still wading through various manuals to get the hang of things in
Oracle but I'm curious, is there a quick and easy way to find
constraints that have been setup on a database?? ie. is it something
like

select blah from constraints_blah    ???


Got myself all happy the other day when I jdbc connected across network
to an access database, now to move onto a jdbc connection across
webserver and do some dynamic content in web pages.


Matthew