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

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
gschiff
Posts: 11
Joined: Wed 23 May 2012 00:50

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

Post by gschiff » Wed 16 Jan 2013 00:46

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
Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Thu 17 Jan 2013 16:39

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

Post Reply