I don't remember the sql offhand, but if you have the Oracle client installed you probably have DBA Studio installed, which can pull these things up for you easily in a GUI.
hmm,brain cells are firing...check the admin views all_constraints and user_constraints--I think they might tell you what you need to know.
