Page 1 of 1

Oracle interview questions

Posted: Thu Jul 14, 2011 3:04 am
by meena
Hi all
Here are the oracle interview questions:
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
calculate_bonus ('A822');

Function can be called from SQL query + explicitly as well
e.g 1)select empno,salary,fn_comm(salary)from employee;
2)commision=fn_comm(salary);

Procedure can be called from begin-end clause.
e.g.
Begin
(
proc_comm(salary);
)
end