I think this is very important to the every developer to know. I want to know how can we protect the PL/SQL source code, so that we can hide the logic what we used to develop the code.
PL/SQL V2.2, available with Oracle7.2, implements a binary wrapper for PL/SQL programs to protect the source code.This is done via a standalone utility that transforms the PL/SQL source code into portable binary object code (somewhat larger than the original).This way you can distribute software without having to worry about exposing your proprietary algorithms and methods.SQL*Plus and SQL*DBA will still understand and know how to execute such scripts.Just be careful, there is no "decode" command available. The syntax is: wrap iname=myscript.sql oname=xxxx.yyy
Depends what you mean.
Use packages to hide implementation details from people using the interface. (Good development practice).
Use the Wrap utility to hide the source code from view: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/wrap.htm#BABEFEJF
No one has followed this question yet.