딕셔너리(List of Dictionaries) : SELECT * FROM dict;
오브젝트 타입(List of Object Types) :
INDEX, JOB CLASS, CONTEXT, TABLE SUBPARTITION, TYPE BODY, INDEXTYPE, DESTINATION, PROCEDURE,
JAVA CLASS, RULE, SCHEDULE, TABLE PARTITION, WINDOW, JAVA RESOURCE, TABLE, TYPE, VIEW, LIBRARY,
FUNCTION, TRIGGER, PROGRAM, MATERIALIZED VIEW, JAVA SOURCE, CLUSTER, SYNONYM, PACKAGE BODY,
CONSUMER GROUP, EVALUATION CONTEXT, RULE SET, SCHEDULER GROUP, DIRECTORY, OPERATOR, JAVA DATA,
EDITION, SEQUENCE, PACKAGE, JOB, INDEX PARTITION, LOB, XML SCHEMA
모든 오브젝트(List of All objects) : ALL_OBJECTS / USER_OBJECTS
테이블(List of Tables) : ALL_TABLES / USER_TABLES
인덱스(List of Indexes) : ALL_INDEXES / USER_INDEXES`
뷰(List of Views) : ALL_VIEWS / USER_VIEWS
컬럼(List of Columns) : all_tab_columns, all_tab_comments, all_col_comments
PK 등 컨스트레인(List of Constraints) : all_constraints, all_cons_columns
'RDBMS > Oracle' 카테고리의 다른 글
Oracle DBA SQL (0) | 2021.01.28 |
---|---|
아카이브 로그(Archive log) 관련 SQL (0) | 2021.01.14 |
문자셋(character set) 확인 (0) | 2020.12.18 |
Gather statistics about objects(통계정보 생성) (0) | 2020.12.18 |
sqlldr - Making datafile&load with ctl file (0) | 2020.12.17 |