select NVL(some_column,0) from some_table where some_condition...