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


Public

Tested

Not My Work
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 73 Downloads 21

SQL Learning Materials
ANmarAmdeen
695
Attachments
Revisions

v1.0