오브젝트, 시노님, 인덱스, 컬럼, 커멘트 조회

select * from ALL_OBJECTS;

select * from ALL_SYNONYMS;

select * from ALL_IND_COLUMNS;

SELECT * FROM USER_TABLES;

select * from ALL_TAB_COLUMNS WHERE TABLE_NAME = 'STAT_TYPE';

select * from ALL_COL_COMMENTS WHERE TABLE_NAME = 'STAT_TYPE';

select * from ALL_COL_COMMENTS WHERE OWNER='TBNSTD' order by TABLE_NAME, COLUMN_NAME;

 

-- 프로시저 목록 보기

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE='PROCEDURE' and owner='TBNSTD';

-- 프로시저 내용 보기

select text from user_source where name='PROC_DAILY_WORK';