|
The SYSPROCS view shows the procedure or function name, the name of its creator and any comments recorded for the procedure or function.
The tables and columns that make up this view are provided in the ALTER VIEW statement below.
ALTER VIEW "SYS"."SYSPROCS"( creator,
procname,remarks)
as select u.user_name,p.proc_name,p.remarks from
SYS.SYSPROCEDURE as p join
SYS.ISYSUSER as u on u.user_id = p.creator