Oracle PL/SQL/SQL Plus/Query Rewrite
Query rewrite enabled
<source lang="sql">
SQL> SQL> SQL> alter session set query_rewrite_enabled=true; Session altered. SQL>
</source>
<source lang="sql">
SQL> SQL> SQL> alter session set query_rewrite_enabled=true; Session altered. SQL>
</source>