Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Different number of decimals in SQL*Plus and SQL Developer

user455466Jun 12 2025

Hi,

How can I get the same number of decimal in SQL*Plus and SQL Developer in the next queries:

  1. SQL Developer:
SQL> 
SQL> set NUMWIDTH 12
SQL> 
SQL> select IMP_TARIFICADO_E from cota_itgptarif where  COD_CORPORATIVO = 199 and NUM_PRIVLLAMANTE = '15016' and nom_fichero = 'CGC20250612-095546-001.039';

IMP_TARIFICADO_E
----------------
 .00086154931745
  1. SQL*Plus:
SQL>
SQL> set NUMWIDTH 12
SQL>
SQL> select IMP_TARIFICADO_E from cota_itgptarif where  COD_CORPORATIVO = 199 and NUM_PRIVLLAMANTE = '15016' and nom_fichero = 'CGC20250612-095546-001.039';
    .00086154932
SQL>

Thanks & regards,

Jose Luis.

Comments
Post Details
Added on Jun 12 2025
1 comment
147 views