Thursday, 12 March 2015

How to remove Scientific Notation for a numeric value in Toad for Oracle

How to remove Scientific Notation for a numeric value in Toad in Oracle
Example of Scientific Notation:-



View/Toad Options/Data Grids/Data
Uncheck "Display large numbers in Scientific Notation" checkbox as mentioned below:-

Run the query again to view full numeric value in the result:-