Printable View
I am in need to call a function in a query. I want the syntax for that. Along with that i have to get some variables values also. So send me one example and the exact syntax to be placed and I dont know where that function should be copied or placed and how to call that function in the query.
[B]Question asked by visitor Nataraj[/b]
You can call the functions as you call predefined functions like TRIM,REPLACE etc. To call a function directly from SQL it should not have any OUT parameter.
Suppose numtowords is a function,
To call a function in query we can write
select sal,numtowords(sal) from emp
select numtowords(1000) from dual.i think i will help u.