====== Oracle - SQL - Display field constraints ======

<code sql>
SELECT constraint_name,search_condition 
FROM user_constraints 
WHERE table_name='tablename';
</code>