Hi,

     You can do something like this. Use NVL

select NVL(product_name, '')
from product;

The above query checks for product_name column in product table. If it is null then it returns empty string.

Hope this solves your problem

Thanks,