테이블 조회(PK,comments포함)

--1. PK 포함하여 테이블 조회
SELECT /*+ ORDERED (A B C D) */ a.table_name, D.COMMENTS, A.COLUMN_ID, A.COLUMN_NAME,
B.COMMENTS,
--C.constraint_name||' '||c.position PO,
DATA_TYPE||'('||DATA_LENGTH||')' DATA_TYPE,
A.NULLABLE,c.position PK
FROM COLS a, DBA_COL_COMMENTS B,
(select *
from all_cons_columns
where constraint_name NOT LIKE 'SYS_C%'
and owner= upper(:table_owner)
and TABLE_NAME = upper(:table_name)
) C, ALL_TAB_COMMENTS d
WHERE A.TABLE_NAME = upper(:table_name)
AND A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_NAME = C.TABLE_NAME(+)
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.COLUMN_NAME = C.COLUMN_NAME(+)
and b.owner= upper(:table_owner)
AND A.TABLE_NAME = d.TABLE_NAME
ORDER BY a.table_name, A.COLUMN_ID, a.nullable