Filtri Menu 0 0.00

Oracle Tip – Set Decimal separator for an oracle session

Oracle Tip – Set Decimal separator for an oracle session

To set in a single session the decimal separator, for example when you need to cast some string in numbers you can use the next istruction :

  ALTER SESSION SET NLS_NUMERIC_CHARACTERS ='. ';

in this case the “decimal separator” is the point “.”.

if you want the parameter is set inside a procedure or a function you can write like this

  EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''. ''';

tested on Oracle version: 10g , 11g

Condividi:

Iscriviti alla newsletter

Iscriviti alla nostra newsletter per ricevere offerte di sconto anticipate, aggiornamenti e informazioni sui nuovi prodotti.
Top