Oracle dict 활용 & Compile ,Drop 쿼리

ORACLE Dictionary 활용

 

1. Dictionary 검색

SELECT * FROM DICT;

 

 

2. 생성된 OBJECTS 확인용 쿼리

SELECT * FROM DBA_OBJECTS;

SELECT * FROM ALL_OBJECTS;

SELECT * FROM USER_OBJECTS;

 

 

3. 해당 OBJECTS SOURCE 확인

SELECT * FROM DBA_SOURCE;

SELECT * FROM ALL_SOURCE;

SELECT * FROM USER_SOURCE;

 

4. Procedure COMPILE 쿼리

ALTER PROCEDURE SP_USER_PROCEDURE COMPILE;

 

 

5. Procedure DROP 쿼리

DROP PROCEDURE SP_USER_PROCEDURE;

 

 

6. Function COMPILE 쿼리

ALTER FUNCTION FN_USER_FUNCTION COMPILE;

 

 

5. 프로시저 DROP 쿼리

DROP FUNCTION FN_USER_FUNCTION;