Which of the following below are types of parameters for a function?

Options
- IN
- OUT
- IN OUT
- All of the above

CORRECT ANSWER : All of the above

Discussion Board
Types of Parameters

In PL/SQL, we can pass parameters to procedures and functions in three ways:

1) IN type parameter: These types of parameters are used to send values to stored procedures.
2) OUT type parameter: These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.
3) IN OUT parameter: These types of parameters are used to send values and get values from stored procedures.

NOTE: If a parameter is not explicitly defined a parameter type then by default it is an IN type parameter.

Prajakta Pandit 02-15-2017 04:39 AM

out parameter

we can have OUT parameter in function,
but it is not advisable as functions are for computations and returning the values 'Return' clause is there.

Deepika S Verma 11-28-2014 06:26 AM

out parameter in function

there is no out patameter in function only return cluese

narendra 10-23-2014 02:47 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲