Using the DECODE function does not show numbers in numeric format in the Data Grid.
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".
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.