오라클 Description 조회 및 수정. ( comment on )

Oracle - comment on table 또는 column  Database  2010/02/27 10:57 http://blog.naver.com/json2811/90082159361

▶ comment on table 테이블명 is '멋진 테이블';

 

▶ comment on column 테이블명.칼럼명 is '더 멋진 칼럼';

 

▶ data dictionary

USER_TAB_COMMENTS
USER_COL_COMMENTS

 

select * from user_tab_comments

where comments is not null

/

 

select * from user_col_comments

where comments is not null

/

[SAMPLE#1]

COMMENT ON COLUMN SAEBIT.ADDITIONCDR_ITEMCOD.TYPE IS '타입';

[SAMPLE#2]

select 'COMMENT ON TABLE '||TABLE_NAME||' IS '||COMMENTS||';' from user_tab_comments where comments is not null  and table_name in ('PBCATFMT', 'PBCATTBL') select 'COMMENT ON COLUMN '||TABLE_NAME||'.'||COLUMN_NAME||' IS '||COMMENTS||';'  from user_col_comments where comments is not null  and table_name in ('PBCATFMT', 'PBCATTBL',)

1. Object 로 조회하기

  > SELECT * FROM all_objects

     WHERE object_type='TABLE'

     AND object_name LIKE '%테이블명 일부%'

 

 

2. all_tables 로 조회하기

  > SELECT * FROM all_tables

     WHERE talbe_name LIKE '%테이블명 일부%'