Print Thread
pl sql developer, insert sequence nextvalue into datatype number(20,6) bug
#64413 02/03/23 09:35 AM
Joined: Jan 2017
Posts: 23
P
ppc Offline OP
Member
OP Offline
Member
P
Joined: Jan 2017
Posts: 23
Pl sql developer, insert sequence nextvalue into datatype number(20,6) bug, Please view the file.

Attached Files
Re: pl sql developer, insert sequence nextvalue into datatype number(20,6) bug
ppc #64415 02/03/23 09:59 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
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.


Marco Kalter
Allround Automations
Re: pl sql developer, insert sequence nextvalue into datatype number(20,6) bug
ppc #64416 02/04/23 12:34 AM
Joined: Jan 2017
Posts: 23
P
ppc Offline OP
Member
OP Offline
Member
P
Joined: Jan 2017
Posts: 23
number fields to char is not conducive to the processing and viewing of data in some cases,
can you fix the bug?
Thanks!


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.072s Queries: 16 (0.047s) Memory: 2.5023 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-04-21 10:24:42 UTC
Valid HTML 5 and Valid CSS