I have a list of packages(BODY and SPEC ) where I want to take a backup. But I want to do it dynamically like :
List of package SPEC:
but I need to save it as :
List of package BODY that I have :
And I need to save/take backup with file name like:
Now how can I do this with a PLSQL block while spooling this to some location in c:\ drive.
And the target is to pass the package name only.
Only thing is that I want to make two blocks :
1) For package SPEC only by passing its name
2) For package BODY only by passing its name