Mega Code Archive
Categories
/
Oracle PLSQL
/
SQL Plus
Set the following session parameters to enable query rewrite
SQL> SQL> ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE; Session altered. SQL> ALTER SESSION SET QUERY_REWRITE_INTEGRITY=ENFORCED; Session altered. SQL> SQL> --