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

Register Log In

Forums General Discussion 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, 6 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: 21,770 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 21,770	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