Procedures & Functions - ORACLE PL/SQL Chapter Wise Interview Questions Question 1: What are the constructs of a procedure, function or a package? Answer: The constructs of a procedure, function or a package are: variables and constants cursors exceptions Question 2: What is the advantage of a Stored Procedure over a Database Trigger? Answer: We have … [Read more...]