Oracle Object Select

Oracle SID:  select instance from v$thread;

DB_NAME:  select name from v$database;

Oracle User:  select * from all_users;

User 목록:  select username, user_id from dba_users order by username;

User 테이블:  select table_name from user_tables;

사용자 정보:   select username, default_tablespace,temporary_tablespace from dba_users;

오브젝트 조회:  select * from all_objects where object_name like '명';

테이블 조회:  select * from all_tables where table_name like '명'; 

시퀀스:  select * from user_sequences;

시노님:  select * from all_synonyms where synonym_name='명';

테이블 인덱스:  select * from all_ind_columns where table_name='테이블명';

테이블의 컬럼:  select * from all_tab_columns where table_name='테이블명';

table comment:  select * from all_tab_comments where table_name='테이블명';

column comment:  select * from all_col_comments where table_name='테이블명';

인덱스:   select index_name from user_indexes;

이 글은 스프링노트에서 작성되었습니다.