Вывести имена ограничений и имена столбцов, на которые они наложены.
SQL> SELECT constraint_name, column_name
2 FROM user_cons_columns;
CONSTRAINT_NAME COLUMN_NAME
-------------------- ------------------------------
E_F_NN FIRST_NAME
E_L_NN LAST_NAME
E_M_FK MANAGER
E_PK ID
E_P_ID_EMP_FK ID_EMP
E_P_ID_PR_FK ID_PR
E_P_PK ID_EMP
E_P_PK ID_PR
P_NAME_NN NAME
P_PK ID
SP_ID_P_FK ID_PROJECT
SP_NAME_NN NAME
SP_PK ID
SP_PK ID_PROJECT
14 rows selected.