DBA_PROCEDURES

ストアド一覧

ストアドパッケージは１行で出力する。

select w.OWNER,w.OBJECT_NAME,w.OBJECT_TYPE,w.PIPELINED,o.STATUS,o.LAST_DDL_TIME 
from (
select
p.OWNER,p.OBJECT_NAME,p.OBJECT_TYPE,p.PIPELINED
from DBA_PROCEDURES p
inner join dba_users u on p.OWNER= u.USERNAME and u.COMMON ='NO'
where 1=1 and
(p.OBJECT_TYPE='PACKAGE' and p.PROCEDURE_NAME is null)
or
(p.OBJECT_TYPE !='PACKAGE')
) w
inner join dba_objects o 
on w.OWNER = o.OWNER and w.OBJECT_NAME = o.OBJECT_NAME and w.OBJECT_TYPE = o.OBJECT_TYPE
order by w.OWNER,w.OBJECT_TYPE, w.OBJECT_NAME
;

ストアドパッケージのプロシージャおよびファンクション一覧

select
p.OWNER,p.OBJECT_NAME,p.PROCEDURE_NAME,p.OBJECT_TYPE,p.PIPELINED
from DBA_PROCEDURES p
inner join dba_users u on p.OWNER= u.USERNAME and u.COMMON ='NO'
where 1=1 and
p.OBJECT_TYPE='PACKAGE' and p.PROCEDURE_NAME is not null
order by p.OWNER,p.OBJECT_TYPE, p.OBJECT_NAME,p.PROCEDURE_NAME
;