πŸ“Š MySQL
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.
  • (A) out-bind
  • (B) in-bind
  • (C) define
  • (D) None of the above
πŸ’¬ Discuss
βœ… Correct Answer: (A) out-bind

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

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

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
171
Total Visits
πŸ“½οΈ
4 y ago
Published
πŸŽ–οΈ
Akshay Kulkarni
Publisher
πŸ“ˆ
82%
Success Rate