find table contstraint in oracle database

problem:
free toad does not provide a constraint view.

solution:
select * from user_constraints where constraint_name = 'THE_CONSTRAINT_NAME';

TABLE_NAME is the name of the table that has the constraint, and probably is the table you need to delete stuff from to clear the constraint