Executing a function or procedure
I always mix up how to executing functions versus a procedure on Oracle
Function
select <schema>.<function>(<params>) from dual;
Procedure
begin <schema>.<function>(<params>); end;
I always mix up how to executing functions versus a procedure on Oracle
select <schema>.<function>(<params>) from dual;
begin <schema>.<function>(<params>); end;