Header Ads Widget

Responsive Advertisement

Module 11: Managing PL/SQL Code

Managing PL/SQL Code 

 01. What Is Conditional Compilation?

Enables you to customize the functionality in a PL/SQL application without removing any source code.

02. Write down the benefits of Conditional Compilation.

Benefits of Conditional Compilation:

a. Support for multiple versions of the same program in one source code.

b. Easy maintenance and debugging of code.

c. Easy migration of code to a different release of the database.

03. What is Obfuscation?


a. Obfuscation (or wrapping) of a PL/SQL unit is the process of hiding the PL/SQL source code.

b. Wrapping can be done with the wrap utility and DBMS_DDL subprograms.

c. The Wrap utility is run from the command line and it processes an input SQL file, such as a SQL*Plus installation script.

d. The DBMS_DDL subprograms wrap a single PL/SQL unit, such as a single CREATE PROCEDURE command, that has been generated dynamically.

04. Write down the benefits of Obfuscation.

Benefits of Obfuscating:

a. It prevents others from seeing your source code.

b. Your source code is not visible through the USER_SOURCE, ALL_SOURCE, or DBA_SOURCE data dictionary views.

c. SQL*Plus can process the obfuscated source files.

d. The Import and Export utilities accept wrapped files.

05. What is wrapper utility?

The PL/SQL wrapper is a stand-alone utility that hides application internals by converting PL/SQL source code into portable object code.

06. Write down the guidelines for wrapping.

Guidelines for Wrapping:

a. You must wrap only the package body, not the package specification.

b. The wrapper can detect syntactic errors but cannot detect semantic errors.

c. The output file should not be edited. You maintain the original source code and wrap again as required.

d. To ensure that all the important parts of your source code are obfuscated, view the wrapped file in a text editor before distributing it.

Post a Comment