[Solved] Condition statement in a select

by 


Select X, Y, NVL(Z, showThis) as Z

will return showThis if Z is null in ORACLE

Select X, Y, ISNULL(Z, showThis) as Z

will return showThis if Z is null in SQL-SERVER

0

solved Condition statement in a select