Question 76 :
What are the modes of parameters that can be passed to a procedure ?
Question 77 :
Where the Pre_defined_exceptions are stored ?
In the standard package.
Procedures, Functions & Packages ;
Question 78 :
Write the order of precedence for validation of a column in a table ?
I. done using Database triggers.
ii. done using Integarity Constraints.
I & ii.
Question 79 :
Give the structure of the function ?
FUNCTION name (argument list .....) Return datatype is
local variable declarations
Question 80 :
Explain how procedures and functions are called in a PL/SQL block ?
Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
What are advantages fo Stored Procedures?
Extensibility,Modularity, Reusability, Maintainability and one time compilation.