The data grid of SQL Navigator 4.5 and 5.0 displays decimals rounded up.
An Oracle 8.0.x client is used to connect to a 9i or 10g database.
1. Prior to connecting to a database, click Options on the login screen and enable the first option, "Use OCI 7 for this connection." This option may also be set globally, by selecting View | Preferences | General | Session | "Use OCI v7" option.
2. Upgrade the Oracle Client to Oracle 8i (8.1.7) or greater. It is recommended that the Oracle client be upgraded to a version that closely matches the database version.
3. Please go to View | Preference | Code Editors | SQL Editor | Check Retrieve all result fields as strings.