Example of a SQL function that returns a non-NULL value even if one of its parameters is NULL
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Thu, 12 Jan 2023 06:21:00 +0000
Message-ID: <BYAPR02MB5925C9793544DCFDF160BDB5EBFD9_at_BYAPR02MB5925.namprd02.prod.outlook.com>
Inbuilt SQL functions seem to return NULL if one of their parameters is NULL. Here are a couple of examples.
Date: Thu, 12 Jan 2023 06:21:00 +0000
Message-ID: <BYAPR02MB5925C9793544DCFDF160BDB5EBFD9_at_BYAPR02MB5925.namprd02.prod.outlook.com>
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-lReceived on Thu Jan 12 2023 - 07:21:00 CET