Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> A question on the NVL to be re cristchened to ISNULL
wanted to know if the oracle supported a varient datatype as to write
a wraper to the nvl function, i discoverd that we cannot do a synonym
for a system functions like NVL but nvl supports a varient datatype or
it may have been designed to have a functin overloading concept in
oracle as its a object oriented database.
but how its developed is not my issue here can there be a varient datatype which it accepts and get me the varient output.
CREATE OR REPLACE FUNCTION ISNULL( ARG1 VARIENT, ARG2 VARIENT)
RETURN VARIENT IS
RTNVAL VARIENT;
BEGIN
RETURN NVL(ARG1,ARG2);
END;
/
SHOW ERRORS;
any answers to this will be appriciated.
Regards
Vinay
Received on Wed Oct 19 2005 - 12:12:23 CDT
![]() |
![]() |