Oracle 테이블 구조 및 설명 보기

--해당 테이블의 컬럼 설명
SELECT
  C.TABLE_NAME,
  C.COLUMN_NAME,
  ACC.COMMENTS,
  C.DATA_TYPE,
  C.DATA_LENGTH,
  C.DATA_PRECISION,
  C.DATA_SCALE,
  C.NULLABLE
FROM
  COLS C, ALL_COL_COMMENTS ACC
WHERE
  C.TABLE_NAME = ACC.TABLE_NAME
  AND C.COLUMN_NAME = ACC.COLUMN_NAME
  AND C.TABLE_NAME = UPPER('table_name')
ORDER BY C.COLUMN_ID ASC;


--해당 테이블의 설명
SELECT * FROM USER_TAB_COMMENTS WHERE TABLE_NAME = UPPER('table_name');

--코멘트로 테이블 확인
SELECT * FROM USER_TAB_COMMENTS WHERE COMMENTS LIKE '%search_word%';

--코멘트로 컬럼 확인
SELECT * FROM ALL_COL_COMMENTS WHERE COMMENTS LIKE '%search_word%';