ORACLE COALESCE()

오라클 COALESCE()

 

COALESCE returns the first non-null expr in the expression list. You must specify at least two expressions. If all occurences of expr evaluate to null, then the function returns null.

 

 

SQL > SELECT COALESCE(NULL, 5,4,3,2,1, 0) FROM DUAL ;

   --> 5

 

SQL > SELECT COALESCE(NULL, 5,NULL,3,2,1, 0) FROM DUAL ;

   --> 5

 

SQL > SELECT COALESCE(NULL, NULL, 0) FROM DUAL ;

   --> 0

 

SQL > SELECT COALESCE(NULL, NULL, 0) FROM DUAL ;

   -->