Viewing a Procedure
I was wondering if anyone could tell me how i can get a copy of a procedure i.e.
I want a copy of the procedure STATSPACK.STAT_CHANGES
I have queried ALL_SOURCE but cant work out how to specifically select the STAT_CHANGES part so I can spool and save it to a file.
Any advice much appreciated....
The source of the mentioned procedure will be available at the
Using OEM/TOAD are some of the ways of extracting the source
Hi Thanks for info
I found the source in %oracle_home/rdbms/admin/spcpkg.sql