Using the NVL function we replace the null values with 'ZERO'. SQL> SELECT id, NVL(col1, 'ZERO') AS output FROM null_test_tab ORDER BY id; ...
確定! 回上一頁