Oracle interview questions

To discuss Oracle Forms & Reports related technical issues.
Post Reply
meena
Posts: 2
Joined: Thu Jun 09, 2011 6:27 am
Location: India

Oracle interview questions

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests