[ORACLE] Get details of constraint by name

select * from all_cons_columns where constraint_name = 'YOUR_CONSTRAINT_NAME';