AUTOMATION BACKUP SCRIPT

It is often a nice to create a set object with Prefix/ Suffix, if so then with below procedure its easy to get all objects source codes in one go.

BEGIN
FOR C IN (SELECT UNIQUE NAME FROM USER_SOURCE WHERE NAME LIKE '%app_prefix or app_suffix%')
LOOP
  HTP.PRINT('----------------------------' || C.NAME || '----' );
 FOR D IN (SELECT TEXT FROM USER_SOURCE WHERE NAME = C.NAME ORDER BY LINE)
  LOOP
   HTP.PRINT(D.TEXT);
  END LOOP;
END LOOP;
END;