테이블 및 컬럼의 COMMENT 확인

 

 

#######################
# 테이블 COMMENTS 확인
######################

SELECT
FROM DBA_TAB_COMMENTS
WHERE OWNER = 'TEST_USER';

#####################
# 컬럼 COMMENTS 확인
#####################

SELECT *
FROM DBA_COL_COMMENTS
WHERE OWNER='TEST_USER';
AND COMMENTS IS NULL;