postgresql7.1
select doc__get_package_header(:package_name) from dual
select doc__get_proc_header(:proc_name, :package_name) from dual
select distinct
substr(proname,1,position('__' in proname)-1) as label,
substr(proname,1,position('__' in proname)-1) as value
from
pg_proc
where
proname like '%\\\_\\\_%'
order by
label
select
'function ' || proname as line_header
from
pg_proc
where
proname like lower(:package_name) || '\\\_\\\_%'
order by
line_header
select
'function ' || substr(proname,length(:package_name)+3) as line_header
from
pg_proc
where
proname like lower(:package_name) || '\\\_\\\_%'
order by
line_header