you can’t specify NULL for exp1 in NULLIF function
select NULLIF(NULL, NULL) from dual;
It will produce an error. (see below)
But you can specify NULL for exp2, it will work
select NULLIF(1, NULL) from dual;
You may also like
What is wrong with the above statement? The Answer: It is not legitimate to specify a length for LOB data types ( […]
NUMBER is a numeric data type that can optionally have a precision and scale specified at creation. The precision can range from […]
This is Oracle 12c feature. Prior to 12c, the DEFAULT for a column would not be applied if you explicitly (or implicitly) inserted a […]
Time. Candidates often either run out of time before finishing every question or have to rush to answer later questions. Time management and […]