executing function on SQL prompt
Hi All
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);
print i
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.
Amol
Re: executing function on SQL prompt
Quote:
Originally posted by amolik
Hi All
print i
Amol
Print???
this seems to be SQL Server command....rather than oracle...
Re: Re: executing function on SQL prompt
Quote:
Originally posted by abhaysk
Print???
this seems to be SQL Server command....rather than oracle...
SQL*Plus reference manual is a good reading sometimes...... ;)
Re: Re: Re: executing function on SQL prompt
Quote:
Originally posted by jmodic
SQL*Plus reference manual is a good reading sometimes...... ;)
I shud start i think...:rolleyes: