Viewing constraints requires creating the constraint for the user table and should include the following:
SELECT * or (column name, column name)
FROM user_constraints
WHERE table_name= [table name];
Constraints not owned by the user may also be viewed by selecting from all constraints.