21 lines
410 B
SQL
21 lines
410 B
SQL
col proc_owner head OWNER for a25
|
|
col proc_object_name head OBJECT_NAME for a30
|
|
col proc_procedure_name head PROCEDURE_NAME for a30
|
|
|
|
select
|
|
owner proc_owner,
|
|
object_name proc_object_name,
|
|
procedure_name proc_procedure_name,
|
|
subprogram_id
|
|
from
|
|
dba_procedures
|
|
where
|
|
object_id like '&1'
|
|
and subprogram_id like '&2'
|
|
order by
|
|
owner,
|
|
object_name,
|
|
procedure_name
|
|
/
|
|
|