Re: Listing the procedures
From: JARED BUDNAROWSKI <jared1_at_vaxb.mdx.ac.uk>
Date: 1995/06/30
Message-ID: <3t1451$eob_at_epsilon.qmw.ac.uk>#1/1
Date: 1995/06/30
Message-ID: <3t1451$eob_at_epsilon.qmw.ac.uk>#1/1
In article <3sfrfb$cjg_at_darwin.nbnet.nb.ca>, iwa_at_csi.nb.ca (Ian Allen) writes:
>Hi,
>
>Can someone tell me if there is a way to list all the pl/sql procedures
>that are in the database. Is there a table that will list them all.
>
>Could you also direct me to the nearest FAQ.
>
>Thank you for your help
Try looking in table user_source for all_source
e.g.
select distinct name from user_source;
list all procedure names in users areas Received on Fri Jun 30 1995 - 00:00:00 CEST