← All field notes

THE ARCHIVE / 4 ENTRIES

2014/06.

BROWSE THE FIELD NOTES

2014/06

4 field notes / page 1 of 1

001Oracle

Oracle 12c – WITH FUNCTION

In Oracle 12c there is a possibility to define a PL/SQL function inside the "WITH" clause, which can reduce the context switching overhead. Short example: SQL> create or replace function F_DUMMY(x number) retur