Decode and NVL

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

CodeFunctionName
What is this?

Public

Tested

Imported
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

Views 1,029

Downloads 383

CodeID
DB ID

ANmarAmdeen
602
Attachments
Revisions

v1.0

Friday
February
7
2020