Dictionary활용 썸네일형 리스트형 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.. 더보기 이전 1 다음