Difference Between Actual and Formal Parameters in PL/SQL

Actual vs Formal Parameters: Explore What is the Difference Between Actual and Formal Parameters in PL/SQL

Actual parameters and Formal parameters are the two concepts that immediately strike our minds when it comes to the oracle database. Both these terminologies are members of the programming world and SQL.

Actual parameters are those parameters that are specified in the calling function. While on the other hand, formal parameters are those parameters that are declared in the called function. Let’s analyze the difference between Actual and Formal Parameters in PL/SQL.

What is an Actual Parameter?

It is the actual value that is assigned to the process by a caller. Or in other words, we can say that it is the parameters that you determine when you invite the subroutine such as, Functions.

What is a Formal Parameter?

A formal parameter is a variable that you specify when you determine the subroutine or function. These parameters define the list of possible variables, their positions, and their data types.

Difference Between Actual and Formal Parameters in PL/SQL

Actual Parameters Formal Parameters
The Actual parameters are the variables that are transferred to the function when it is requested. The Formal Parameters are the values determined by the function that accepts values when the function is declared.
In actual parameters, only the variable is mentioned, not the data types. In formal parameters, the data type is required.
Actual parameters are the values referenced in the parameter index of a subprogram call. Formal parameters are the values referenced in the parameter index of a subprogram.
In actual parameters, there is no requirement to define datatype. In formal parameters, it is mandatory to define the datatype of the receiving value.
These can be variables, constants, and expressions, without data types. Formal parameters are variables with the data type.
Those parameters which are addressed in a function call are called actual parameters. Parameters addressed in the function description are called formal parameters.

Keep learning and stay tuned to get the latest updates on GATE along with GATE Preparation Books & GATE Answer Key and more.

Also Explore,

Leave a Comment

Your Mobile number and Email id will not be published.

*

*