테이블정의서(칼럼뽑기)

SELECT
A.TABLE_NAME ,
B.COMMENTS BC ,
A.COLUMN_NAME ,
C.COMMENTS CC ,
A.DATA_TYPE ,
A.DATA_LENGTH ,
A.DATA_PRECISION ,
A.DATA_SCALE ,
A.NULLABLE ,
A.COLUMN_ID ,
A.DATA_DEFAULT
FROM USER_TAB_COLUMNS A ,
USER_TAB_COMMENTS B ,
USER_COL_COMMENTS C
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.TABLE_NAME = C.TABLE_NAME
AND A.COLUMN_NAME = C.COLUMN_NAME