Category Archives: WriteLessWithMore

PL/SQL in SQL in View in SQL in PL/SQL

I presented “Write Less (Code) With More (Oracle 12c New Features)” yesterday at OGh Tech Experience 2017. One of the features I talked about was PL/SQL in the WITH Clause. One of the restrictions of this feature is that you cannot embed a static SQL query, that contains PL/SQL in the WITH clause, in PL/SQL […]

Continue reading

Who Rewrote My SQL?

Oren Nakdimon Leave a Reply

There are several new features in Oracle 12c that are implemented under the hood by changing the SQL statement that we write to a different statement (e.g., by adding some hidden predicates). In OUG Ireland 2016 I talked about two such features – In Database Archiving and Temporal Validity – as part of my “Write […]

Continue reading