Re: listing funcs and procs
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 2 Apr 2010 06:57:53 -0700 (PDT)
Message-ID: <3e3421e8-7c48-47dc-9d94-00c3394637f8_at_z11g2000yqz.googlegroups.com>
On Apr 1, 3:45 pm, seannakasone <snaka..._at_flex.com> wrote:
> Hi, anyone have code snippets on how to list out user functions and
> procedures? perhaps there is a table or view that contains
> this information, like user_procs or user_funcs or something like that.
> Thanks,
> Sean
Date: Fri, 2 Apr 2010 06:57:53 -0700 (PDT)
Message-ID: <3e3421e8-7c48-47dc-9d94-00c3394637f8_at_z11g2000yqz.googlegroups.com>
On Apr 1, 3:45 pm, seannakasone <snaka..._at_flex.com> wrote:
> Hi, anyone have code snippets on how to list out user functions and
> procedures? perhaps there is a table or view that contains
> this information, like user_procs or user_funcs or something like that.
> Thanks,
> Sean
Beides looking in dba_objects and dba_arguments as Michel mentioned there is another view that may be of interest: all_procedures
It can be used to identify if the procedure is pipe_lined, aggregate, etc ....
HTH -- Mark D Powell -- Received on Fri Apr 02 2010 - 08:57:53 CDT