Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Call function in a query
This is a discussion on Call function in a query within the SQL forums, part of the Databases category; 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 ...
|
|||||||
09-20-2007
|
|||
|
|||
|
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 
|
| The Following User Says Thank You to Geek_Guest For This Useful Post: | ||
| Sponsored Links |
|
09-20-2007
|
|||
|
|||
|
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.
|
|
10-11-2007
|
|||
|
|||
|
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.
|
| The Following User Says Thank You to susarlasireesha For This Useful Post: | ||
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I get error "invalid call to function"... | JobHelper | QTP | 1 | 06-23-2008 04:10 PM |
| I would like to call the function in Javascript | saranyamahendran | C# | 1 | 10-15-2007 04:14 AM |
| Query about a Function | Remasri | PHP | 3 | 03-17-2007 03:10 AM |
| How can i call that function? | JobHelper | Java | 1 | 12-06-2006 03:16 AM |
| Query with a Function in C | joel | C and C++ | 1 | 07-16-2006 12:33 PM |
All times are GMT -4. The time now is 05:58 PM.
