DBMS ADVANCED REWRITE

DBMS_ADVANCED_REWRITE is a PL/SQL package that allows you to transform queries on the fly. This is mostly useful for query tuning. For example, it allows you to optimized an application's SQL without modifying the application.