Questions
Tags
I created a function in oracle that inserts records in specific tables and return an output according to what occurs within the function. e.g (ins_rec return number)
How do I call this function and see its output in sql plus
This question is related to oracle function sqlplus
oracle
function
sqlplus
declare x number; begin x := myfunc(myargs); end;
Alternatively:
select myfunc(myargs) from dual;