RDBMS/Oracle

OBJECT 조회

KSerin 2020. 12. 17. 20:13
728x90

딕셔너리(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

728x90