CODE EXAMPLE FOR SQL

how to check constraints on a table in sql oracle

SELECT *
  FROM user_cons_columns
 WHERE table_name = '<your table name>';