NVL2 Function

NVL2 Function NVL2: check for the existence of NOT NULL Most of us are familiar with the NVL function which checks for the existence of NULL values. Oracle provides a new function called NVL2 which checks for the existence of NOT NULL. The syntax for this function is as follows. NVL2(expr1,expr2,expr3); If expr1 is not … Continue reading

ORACLE BULK COLLECT

ORACLE BULK COLLECT Oracle uses two engines to process PL/SQL code. All procedural code is handled by the PL/SQL engine while all SQL is handled by the SQL statement executor, or SQL engine. There is an overhead associated with each context switch between the two engines. If PL/SQL code loops through a collection performing the … Continue reading