Preventing "(null)" from appearing in query results and copied data

[gschiff]

I use dbForge to do a lot of data browsing, often copying the query results into MS Excel.

I would like to suppress the transfer of the string "(null)" into Excel when I copy data. In fact, I don't really want to see it in the query results in dbForge, I would prefer to see empty cells for null values.

I searched the options but could not find any way to change the default behavior.

Is there a way to get my nulls to appear as empty?


Thanks,
Garrett Schiff

[alexa]

Hello Garrett,

There is no particular functionality in dbForge Studio for Oracle right for this purpose. However, this can be achieved as follows:

Select IF(a.UserID IS NULL, '',a.UserID) from a