If you are a dba then you can use the dba_constraints, if you are a user then you can use the user_constraints to view all the constrains under your schema.

SELECT * FROM dba_constraints;

or

SELECT * FROM user_constraints;

Good luck,
Sam

[Edited by sambavan on 03-19-2001 at 03:33 PM]