Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract quickly all the procedures in different files

Mark1970Dec 13 2011 — edited Dec 15 2011
Hi,
I need to extract quickly all the procedures, packages and functions from my DB and put them automatically in files (proc1.prc, proc2.prc, package1.pck, function1.fnc, ...)
Have you got any sql to perform also in SQL Plus for doing it?
My Oracle version is 8.1.7
Thank you very much!

Edited by: Mark1970 on 13-dic-2011 1.07
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2012
Added on Dec 13 2011
6 comments
793 views