-
タイトル
Toad shows Long column types as Number for Oracle Fusion table columns. -
説明
Toad shows Long column types as Number for Oracle Fusion table columns. The last 3 characters of column data are E00 and column type is shown as Number rather than Long.
-
原因
The data inconsistency is sourced from Oracle Fusion, where some records in the column are stored as whole numbers (e.g., 1), while others contain high-precision decimal values. The database column has no defined precision (NUMBER without DATA_PRECISION and DATA_SCALE values), meaning Oracle Fusion allows values with arbitrary precision. When numbers are stored with extreme precision, Oracle sometimes returns them in scientific notation (E00 format).
-
対策
Toad Data Studio is displaying the data exactly as received from Oracle Fusion. It does not modify numeric values. The inconsistency is due to how Oracle Fusion stores and returns numerical value (and not an issue with Toad).
If a consistent decimal format is required, users should explicitly format values using SQL: SELECT TO_CHAR(<column name>, '9999999999.0000000000') AS FORMATTED_RATE FROM GL_JE_LINES;This ensures that even whole numbers (1) display as 1.0000000000, maintaining consistency.