Posted By: ppc pl sql developer, insert sequence nextvalue into datatype number(20,6) bug - 02/03/23 09:35 AM
Pl sql developer, insert sequence nextvalue into datatype number(20,6) bug, Please view the file.

Attached File
Posted By: Marco Kalter Re: pl sql developer, insert sequence nextvalue into datatype number(20,6) bug - 02/03/23 09:59 AM
This is a floating point rounding issue. If you go to Preferences > SQL Window you can enable the "Number fields to_char" option to display the number values with full Oracle precision in the SQL Window.
Posted By: ppc Re: pl sql developer, insert sequence nextvalue into datatype number(20,6) bug - 02/04/23 12:34 AM
number fields to char is not conducive to the processing and viewing of data in some cases,
can you fix the bug?
Thanks!
© Allround Automations forums