Toad World® Forums

Numbers displayed in Grid are rounded

With an Oracle database, the column is defined as Number with COLUMN_SIZE = 38 and DECIMAL_DIGITS is null.
Query:
select column from table where column=14491849

TDP grid shows column value as 14491850

I have tried setting the Tools > Options > Environment > Grid
with Number > Custom: ################

I switched from an ODBC Generic connection to an Oracle connection, and the data is displayed correctly.