행위

ORACLE 프로시져 추출쿼리

DB CAFE

* 프로시져 추출 
select  OWNER 
    ,  NAME 
    ,  TYPE 
    ,  LINE 
    ,  decode(line,1,'CREATE OR REPLACE ' 
        ||replace(text,'PACKAGE BODY ','PACKAGE BODY ' 
        ||owner 
        ||'.'),text) AS PKG_SOURCE 
from dba_source where type='PROCEDURE' and owner='$ownerName';