Difference between Procedure and function

Question

Accepted Answer

Procedures and functions are both PL/SQL program units, but they have some key differences.

Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL statements, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
Procedures are typically used for performing actions, while functions are used for calculations or data retrieval.

Accepted Answer

Function calculates the result of the given input of a program and procedure means its a certain task in a particular order based on the given input

Accepted Answer

function must be return value but procedure may or may not be contain return value.

function can be called sql statement but procedure can not call sql statement

function can compile every time but procedure compile one time

Accepted Answer

Function must returns the values but procedure may contain or may not contain Return values

Accepted Answer

procedure is used to perform particular tasks.
out parameter is used to return output.
can perform DML operations and not call from select statement.
we can call function from procedure.
procedure may or maynot return a value.
there is no need to write return datatype at the time of procedure creation.
procedure compile once until do any modification.

function is used for calculation purpose.
return keyword is used to return output.
cannot perform DML operations and call from select statement.
we cannot call procedure from function.
function must return a value.
need to write return datatype at the time of function creation.
function complie everytime while executing .

Difference between Procedure and function

Top Cognizant Plsql Developer interview questions & answers

Popular interview questions of Plsql Developer