The counting method for displaying the content with a field type of number and a length greater than 16 bits as a scientific notation from the pl/SQL query field

The counting method of querying a field type from pl/SQL is number and the length is greater than 16 bits is displayed as scientific notation pl/SQL query field type from pl/SQL is number and the length is greater than 16 bits the content is displayed as the counting method of scientific notation, the following solution is found: 1. in toad, choose view> option> data> display large number in scientific notation, if you do not select this option, select pl/SQL developer> tools> preferences> SQL windows> number fields tochar. 2. view the numw parameter SQL> show numw numwidth 10 and modify this parameter to the required number of digits. For example, the field content can be queried after set numw 19.