DESCRIBE FUNCTION nvl; DESCRIBE FUNCTION EXTENDED nvl; EXPLAIN SELECT NVL( 1 , 2 ) AS COL1, NVL( NULL, 5 ) AS COL2 FROM src LIMIT 1; SELECT NVL( 1 , 2 ) AS COL1, NVL( NULL, 5 ) AS COL2 FROM src LIMIT 1;