Wednesday, July 17, 2013

Run oracle function using Dual

 Say you have a function called FUNCTION_TEST with M number of parameters.You can get return value of function easily as follows.

 SELECT
    FUNCTION_TEST(PARAMETER_1,PARAMETER_2,....PARAMETER_M)
 AS
    RETURN_VALUE
 FROM
    DUAL

No comments:

Post a Comment