203 (1) 썸네일형 리스트형 113 - [Oracle PL/SQL] Dependencies - Impact on the Package 테스트용 패키지와 프로시져 생성create or replace package pkgis procedure p1;end;/create or replace package body pkgis procedure p1 is begin dbms_output.put_line ('welcome'); end;end;/--프로시져에서 패키지.프로시져 호출create or replace procedure call_from_pkgisbegin pkg.p1;end;select object_name, object_type, created, statusfrom user_objectswhere lower(object_name) in ('pkg','call_from_pkg');------.. 이전 1 다음