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;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s