extraction of oracle pkg and pkg bodies into spool file

[mdvreddy]

Hi,

I need to extract all packages and its bodies into spool file. can you give me script or guide how to do this.. i have more than 200 packages.. need to create spool file for each package. great thanks for help.
/mr

[davey23uk]

better to go to your source control system where you will keep copies of these things - much easier

[mdvreddy]

i wrote a small sql script with which i completed this task.. thanks all.