(위키로이동완료) 오라클 시스템 참조 쿼리 (oracle object select)

오라클 시스템 참조 쿼리

/* ORACLE TABLE SELECT QUERY - SIMPLY */
SELECT * FROM CAT;

/* ORACLE TABLE SELECT QUERY - FULL */
SELECT * FROM ALL_TABLES;

SELECT * FROM ALL_OBJECTS;

SELECT * FROM USER_OBJECTS;

/* FUNCTION OR PROCEDURE SOURCE SELECT */
SELECT * FROM USER_SOURCE;

SELECT * FROM ALL_SOURCE;

/* TABLE COLUMN SELECT */
SELECT * FROM COLS;