SELECT B.COLUMN_NAME AS B_COLUMN_NAME,
     B.TABLE_NAME AS B_TABLE_NAME,
     C.COLUMN_NAME AS C_COLUMN_NAME,
     C.POSITION AS POSITION,
     C.CONSTRAINT_NAME AS CONSTRAINT_NAME
   FROM SYS.ALL_CONSTRAINTS A
     INNER JOIN SYS.ALL_CONS_COLUMNS B ON ((A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME) AND (A.OWNER = B.OWNER))
     INNER JOIN SYS.ALL_CONS_COLUMNS C ON ((A.CONSTRAINT_NAME = C.CONSTRAINT_NAME) AND (A.OWNER = C.OWNER) AND (A.TABLE_NAME = C.TABLE_NAME) AND (B.POSITION = C.POSITION))
   WHERE ((A.OWNER = 'MY_SCHEMA')  AND (A.TABLE_NAME = 'MY_TABLE') )