RETURNING CLAUSE with BULK COLLECT
RETURNING Clause Using Bulk Collect 1. Overview The RETURNING clause can return multiple rows of data, in which case you will use the RETURNING BULK COLLECT INTO form.…
Read MoreReturning Clause in Oracle Plsql
Use RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read MoreRESULT CACHE FUNCTION
1. Overview This Document is about to store the function result into the server result cache. 2. Technologies and Tools Used The following technologies have been used to achieve this Oracle…
Read MorePrivate Temporary Tables
1. Overview This document is about the new features in Oracle 18c is Private Temporary Tables. 2. Technologies and Tools Used The following technologies have been used to achieve this Oracle…
Read MoreGlobal Temporary Tables
1. Overview This Document is about the data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific…
Read More