How to get the details about any constraint in Oracle XE?

When you do some SQL statement in oracle, it throw an exception when your statement violate some constraint. But the error doesn't show about what table the constraint is related, showing just the constraint name.

To show the constraint details just execute the follow sql statement:

SELECT CONSTRAINT_NAME, TABLE_NAME FROM USER_CONSTRAINTS WHERE CONSTRAINT_NAME='FK1_MY_CONSTRAINT_NAME';