Re: Example of a SQL function that returns a non-NULL value even if one of its parameters is NULL

concat()

SQL> select concat('a',null) from dual;

C
-
a

1 row selected.

SQL> select concat(null,'a') from dual;

C
-
a

1 row selected.

Regards
Jonathan Lewis

On Thu, 12 Jan 2023 at 06:21, Iggy Fernandez <iggy_fernandez_at_hotmail.com> wrote:

> Inbuilt SQL functions seem to return NULL if one of their parameters is
> NULL. Here are a couple of examples.
>
> INSTR(NULL, 'Hello, World!')
> INSTR('Hello, World!', NULL)
>
> Can anyone think of an inbuilt SQL function that returns a non-NULL value
> even if one of its parameters is NULL?
>
> Best,
> Iggy
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l