sqloracle-databasenullnvl

Oracle nvl function not working as expected

I want to convert null values to ' '. But when I use this code I got null values as 'NULL':

SELECT NVL(column_a, ' ') FROM table_a
Solution

  • If your GUI displays "NULL" for those values, it is the GUI setting, not Oracle value. Set it to something else (e.g. nothing, in your case).