How to execute a FUNCTION on SQL prompt. I know about using the command 'variable ' and then assigning output to it. But I dont know how to assign returning value of a function to it.
I have done
variable i number
i := exec reval(2);
This does not work but ....
If I execute it in begin ... end block it shows proper out put.
What is the way I can see output in variable i.