Concepts and Architecture Interview Question:

Tell me how to encrypt and decrypt oracle procedure?

Submitted by: Administrator

The WRAP utility 'wraps', or hashes, the PL/SQL source code, but will not 'unwrap' it to restore the plain text starting point. Oracle can decipher this 'translation' internally, however to edit the code one must retain the plaintext source.WRAP is intended to obfuscate source code distributed to client sites in an effort to prevent prying eyes from seeing the underlying logic and to prevent any unauthorized code modification by the client.Again, there is no UNWRAP utility, so, once code is WRAPed it remains such to the naked eye.
Submitted by: Administrator