행위

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='FUNCTION' and owner='$ownerName';