-
Call function in a query
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
-
Re: Call function in a query
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.
-
Expert Member
Re: Call function in a query
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules