[ORACLE] 테이블의 Primary Key Column 조회 Query 문

-- PK 조회

SELECT A.TABLE_NAME, B.COLUMN_NAME, A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.SEARCH_CONDITION
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B
WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.TABLE_NAME = 'TB_REFUND_APP_LIST_PILOT'
AND A.CONSTRAINT_TYPE = 'P';