How to find trigger in oracle

You can use the following query to find out triggers for a particular table

select trigger_name from user_triggers where table_name='XXXX';

Use the name of your table instead of XXXX.

How to find constraint definition in oracle

You can find the definition of a constraint by using the following query

select DBMS_METADATA.GET_DDL('CONSTRAINT', 'XXXX') from dual;

Here instead of XXXX you have to use the name of the constraint.

How to find constraint in oracle

You can find out the name of the constraints for a particular table
from the view user_constraints .

Use the following query

select CONSTRAINT_NAME from user_constraints where table_name='XXXX';

Use the name of your table instead of XXXX.