So I decided to give it a try on every type of DML (INSERT, UPDATE, DELETE and MERGE).
Don't forget to put the WITH_PLSQL "hint" to avoid getting an "ORA-32034: unsupported use of WITH clause":
Ref: http://www.oracle-base.com/articles/12c/with-clause-enhancements-12cr1.php#with-plsql-hint
Doc: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#SQLRF55665
Tuesday, July 2, 2013
WITH_PLSQL hint - Oracle 12c New feature
This weekend I read about the new WITH_PLSQL "hint" on several sites. I looked in the official documentation and I saw this:
So I decided to give it a try on every type of DML (INSERT, UPDATE, DELETE and MERGE).
Don't forget to put the WITH_PLSQL "hint" to avoid getting an "ORA-32034: unsupported use of WITH clause":
Ref: http://www.oracle-base.com/articles/12c/with-clause-enhancements-12cr1.php#with-plsql-hint
Doc: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#SQLRF55665
So I decided to give it a try on every type of DML (INSERT, UPDATE, DELETE and MERGE).
Don't forget to put the WITH_PLSQL "hint" to avoid getting an "ORA-32034: unsupported use of WITH clause":
Ref: http://www.oracle-base.com/articles/12c/with-clause-enhancements-12cr1.php#with-plsql-hint
Doc: http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#SQLRF55665
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment