Call function in a query

[Geek_Guest]

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.

Question asked by visitor Nataraj

[debasisdas]

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.

[susarlasireesha]

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.