| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: What is difference between a formal and an actual parameter?
Answer:
The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters |
| November 11, 2007 01:30:30 |
#2 |
| rajakumar_na |
Oracle Expert Member Since: November 2007 Total Comments: 25 |
RE: What is difference between a formal and an actual ...
|
Formal Parameter: A variable declared in the parameter list of a subprogram specification
Example:
create or replace procedure/function x (p_id number, p_sal number)
Actual Parameter: A variable or expression refrenced in the parameter list of a subprogram call.
example:
execute x( 100,v_sal) |
| |
Back To Question | |
