can we have more than one RETURN statement in a function in PL/SQL ??
I know that we can have two RETURN statements in the following format:
if(condition) then
return .. ;
else
return.. ;
end if;
but that is not the actual answer. Please help.
can we have more than one RETURN statement in a function in PL/SQL ??
I know that we can have two RETURN statements in the following format:
if(condition) then
return .. ;
else
return.. ;
end if;
but that is not the actual answer. Please help.
Fuction returns only one value. To return amount of data at a time use
oracle pipelined functions
You can specify as many number of return statements , but only one out of those will execute depending on the condition.