Replacing NVL Function with Case Statements in OBIEE

Find the Schema  for the data object 

select * from dba_objects where object_name like '%JTF_RS_SALESREPS%';

----------------------------------------------------------------------------------------------------------------

Replacing NVL Function with Case Statements in OBIEE

A user in Oracle forums today had a question regarding using the following expression in OBIEE:

NVL (A_Date,NVL (B_Date.SYSDATE) - C_Date


This could be possible in two ways, first one using the case statement and second one using IFNULL function.


CASE WHEN A_Date IS NULL THEN (CASE WHEN B_Date IS NULL THEN CURRENT_DATE ELSE B_Date END) END

-------------------------------------------------------------------------------------------------------------------

TO GENERATE SQL QUERY IN OBIEE PREFIX::

SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;