Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> A question on the NVL to be re cristchened to ISNULL

A question on the NVL to be re cristchened to ISNULL

From: <bhushanvinay_at_gmail.com>
Date: 19 Oct 2005 10:12:23 -0700
Message-ID: <1129741943.043149.305790@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US