Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”

How an error caused by running analyze on a table with unusable indexes is solved with regular expressions and dbms_stats.

How to hide PL/SQL source code? Use Wrap

How to hide stored PL/SQL source code: packages, procedures, and functions in Oracle, using the wrap utility