Might be you are asking about how to get the value returned by the function.
You can use the function in SELECT Query. You can do something like as below.
insert into Result_tab
select fun from dual;
I am using SQL developer Unit testing Tool for testing of SP's and functions.
I am testing a given function which returns a value.
After the test case is completed returned by a function (example: RETURNS$) is some table , i want to save that value in some table like Result_tab
but i am not sure how to get the value returned by the function.
Your question isn't clear.
What, exactly, does the function return? First you say 'returns a value', then you say what is returned is 'some table', then you again say it is a 'value'.
Apologies for the confusion
The function returns a value which i want to store in some table RESULTS_TAB1