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 17 changed 2 lines
This function will take as many parameters as you want, and will just proceed through the values supplied in order, until it finds a non null value. This is much more performant than use a series of [NVL] constructs to accomplishe the same task (i.e. NVL(NVL(alpha,'A'),'B')
This function will take as many parameters as you want, and will just proceed through the values supplied in order, until it finds a non null value.
At line 22 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 {{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.
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
At line 23 added one line
{{NVL(easd_hours,NVL(dwr_hours,NVL(dps_hours,NVL(djb_hours,dgr_hours))))}}
At line 25 added 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