This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB rforbes to previous
3 26-Nov-2021 10:22 1 KB rforbes to previous | to last
2 26-Nov-2021 10:22 1 KB rforbes to previous | to last
1 26-Nov-2021 10:22 1 KB rforbes to last

Page References

Incoming links Outgoing links
COALESCE
COALESCE

Version management

Difference between version and

At line 21 changed one line
will look at the first variable's value and if it is not null, return that; if it is null, it will go to the second variable and examine its value. If it is not null, it will return that, otherwise it will go to the third variable and examine its value (and so on) until the final value which will be returned (even if it is NULL). This has the same effect, but is much more performant than
will look at the first variable's value and if it is not null, return that; if it is null, it will go to the second variable and examine its value. If it is not null, it will return that, otherwise it will go to the third variable and examine its value (and so on) until the final value which will be returned (even if it is NULL). This has the same effect, but is much more performant than {{NVL(easd_hours,NVL(dwr_hours,NVL(dps_hours,NVL(djb_hours,dgr_hours))))}} especially when there is many values to test. It also has the same effect as a [CASE|ORACLE CASE WHEN] statement that compares each of the values.
At line 23 removed one line
{{NVL(easd_hours,NVL(dwr_hours,NVL(dps_hours,NVL(djb_hours,dgr_hours))))}}
At line 25 removed 3 lines
especially when there is many values to test. It also has the same effect as a [CASE|ORACLE CASE WHEN] statement that compares each of the values.
This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbesTop