자주 쓰는데 잘 까먹는 거라...
SELECT문서 만들때 참 많이 쓰는....
A.TABLE_NAME, A.COLUMN_NAME, A.COMMENTS, B.DATA_TYPE, B.DATA_LENGTH, B.NULLABLE
FROM
USER_COL_COMMENTS A, USER_TAB_COLUMNS B
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME = 'SAMPLETABLE'
;