Two oracle SQL functions, that are interesting.
Decode to work as (Select Case)
And NVL to work as fixing the DBNull situation in database, or replace
Decode(X, Y, Z, De) > > > IF X = Y bring Z otherwise bring De
Decode(X, Y1, Z1, Y2, Z2, Y3, Z3, De) > > > If X = Y1 bring Z1 Elseif X = Y2 bring Z2 Elseif X = Y3 bring Z3 otherwise bring De
NVL(Nuu, New) > > > If Nuu is null bring New otherwise bring Nuu
Decode(X, Y1, Z1, Y2, Z2, Y3, Z3, De) > > > If X = Y1 bring Z1 Elseif X = Y2 bring Z2 Elseif X = Y3 bring Z3 otherwise bring De
NVL(Nuu, New) > > > If Nuu is null bring New otherwise bring Nuu
Views 1,029
Downloads 383
CodeID
DB ID
ANmarAmdeen
602
Revisions
v1.0
Friday
February
7
2020