ORACLE 각종 조회 쿼리

1. 테이블
select object_name from user_objects where object_type = 'TABLE';
2. 뷰
select object_name from user_objects where object_type = 'VIEW';
3. 시퀀스
select object_name from user_objects where object_type = 'SEQUENCE';
4. 인덱스
select object_name from user_objects where object_type = 'INDEX';
5. 프록시져
select object_name from USER_PROCEDURES;
6. 트리거
select trigger_name from user_triggers;
7. 패키지
select object_name from user_objects where object_type = 'PACKAGE';
8. 롤
select GRANTED_ROLE from user_role_privs;
9. 테이블스패이스
select DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from user_users;
10. 시노늄
select * from user_synonyms where TABLE_OWNER = user;
11. 함수
select object_name from user_objects where object_type = 'FUNCTION';

부가정보 뷰에서 정보를 보여주기 위한 쿼리..
1. 테이블
select TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE from USER_TAB_COLUMNS where table_name like '%s';
2. 뷰
select VIEW_NAME, TEXT_LENGTH, VIEW_TYPE_OWNER from USER_VIEWS where VIEW_NAME like '%s';
3. 시퀀스
select SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, INCREMENT_BY, CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE, LAST_NUMBER from USER_SEQUENCES where SEQUENCE_NAME like'%s';
4. 인덱스
select INDEX_NAME, TABLE_NAME, COLUMN_NAME, COLUMN_POSITION, DESCEND from user_ind_columns where INDEX_NAME like '%s';
5. 프록시져
select PROCEDURE_NAME, AGGREGATE, PIPELINED, PARALLEL, INTERFACE, DETERMINISTIC, AUTHID from USER_PROCEDURES where PROCEDURE_NAME  like '%s';
6. 트리거
select TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT, TABLE_OWNER, TABLE_NAME, COLUMN_NAME from USER_TRIGGERS where TRIGGER_NAME like '%s'
7. 롤
select GRANTED_ROLE, ADMIN_OPTION, DEFAULT_ROLE, OS_GRANTED from user_role_privs;
8. 시노늄
select SYNONYM_NAME, TABLE_OWNER, TABLE_NAME, DB_LINK from USER_SYNONYMS where SYNONYM_NAME like '%s'