Running a query in Editor that uses the DECODE function and the outcome for the DECODE function results in either NULL value or a numeric value. However, the numbers are not displayed as right-justified and hence do not have the numeric format in the Data Grid. Both the following options are also checked in Options:
"Retrieve all result fields as strings."
"Retrieve large number as string".