Wrap:
To convert PL/SQL code into binary format we can use the wrap option. wrap is availbale in oracle/ora92/bin directory
wrap will produce a file which is a binary version of the input file. The binary file can be compiled by oracle. But there is no decode option available using which you can convert back the original file from the binary version of the code. Hence it always better to store the original file as well.
How to exclude an Index:
The following are the ways in which we can make the query not to include the index on the column
1.Adding an expression to the indexed column
Eg : Select count(*) from employees where (emp_id)+0 = 1000;
2.Specifying the FULL hint to force full table scan
Eg : Select /*+ FULL(employees)*/ * from employees where emp_id = 1000;
3.Specifying NO_INDEX hint
Eg : Select /*+ NO_INDEX*/ * from employees where emp_id = 1000;
4.Using a function over the indexed column
Eg : Select * from employees where to_number(emp_id) = 1000;