Using the DECODE function does not show numbers in numeric format in the Data Grid. (4302816)

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".

This is an Oracle issue with DECODE function documented in Oracle Metalink Doc ID 149016.1. The DECODE function returns the result in VARCHAR format at times.

Ensure the first value returned in the list of returned values in the DECODE function is a number. Hence, if the original DECODE looks like the following where the first value returned is NULL:
select prodid,
decode(trim(field1),'012', null,'010',null,'015',null,'016',null,'017',null,to_number(prodid)) os
from product;

Then change it to the following, so the first value returned is a numeric value, such as FIELD1, and place a condion that is never True:
select prodid,
decode(trim(field1),'xxx', field1,'010',prodid,'015',prodid,'016',prodid,'017',to_number(prodid),to_number(prodid)) os
from product;