필드 정보 가져오기

SELECT *
FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME LIKE '%필드명%'
;

SELECT *
FROM ALL_COL_COMMENTS
WHERE OWNER = '유져명'
AND COMMENTS LIKE '%코멘트%'
;

코멘트 추가하는 oracle query
comment on table [테이블명] is '코멘트'
comment on column [테이블명].[컬럼명] is '코멘트'