Title: View constraints with table definition and the data dictionary.
Course: Database Design and Management (Oracle) (10052) > Section: Defining Database Constraints

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.