Oracle - SQL - Display field constraints
SELECT
constraint_name
,
search_condition
FROM
user_constraints
WHERE
TABLE_NAME
=
'tablename'
;