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

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

Postby 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
gschiff
 
Posts: 11
Joined: Wed 23 May 2012 00:50

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

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


Return to dbForge for Oracle