Out-bind Operation - Definition - Tuning PL/SQL Applications

Q.  In which binding operation a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.
- Published on 19 Oct 15

a. out-bind
b. in-bind
c. define
d. None of the above

ANSWER: out-bind
 
The INSERT,UPDATE,DELETE statements have the out bind variables. They are bulk binded with the RETURNING BULK COLLECT INTO clause of EXECUTE IMMEDIATE.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)