Hi,
How can I get the same number of decimal in SQL*Plus and SQL Developer in the next queries:
- 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
- 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.