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 15a. 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.
