Re: A question on the NVL to be re cristchened to ISNULL

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 19 Oct 2005 21:04:47 -0700
Message-ID: <5OCdnVhuq_aaisrenZ2dnUVZ_sudnZ2d@comcast.com>

<bhushanvinay_at_gmail.com> wrote in message news:1129741943.043149.305790_at_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
>

You can use function overloading. Just define a different function (same name, but different datatypes) and it will work as advertised. Oracle will choose the right one.
Jim Received on Wed Oct 19 2005 - 23:04:47 CDT