pl sql developer, insert sequence nextvalue into datatype number(20,6) bug - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer pl sql developer, insert sequence nextvalue into datatype number(20,6) bug

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 OP Member
OP ppc 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 pl sql developer, insert sequence nextvalue into datatype number(20,6) bug.pdf (247.05 KB, 7 downloads) telegram id: https://t.me/googledriver

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,211 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,211	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 OP Member
OP ppc 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! telegram id: https://t.me/googledriver

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.045s Queries: 17 (0.012s) Memory: 2.5006 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-08 03:00:07 UTC
Valid HTML 5 and Valid CSS