SQL & PL/SQL

Hi

I have the following decimal format parameters:

SQL> select value
2 from v$nls_parameters
3 where parameter = 'NLS_NUMERIC_CHARACTERS';

VALUE
----------------------------------------------------------------
,.

If I show a number with decimal I get a comma as the decimal separator
SQL> select 10/100 from dual;

10/100
----------
,1

But if I use a decimal separator in the SELECT clause I get:

SQL> select 100 * 1,1 from dual;

100*1 1
---------- ----------
100 1

It doesn't work. But using a period as the decimal separator works:

SQL> select 1.1 * 100 from dual;

1.1*100
----------
110

Maybe this is something I've never had to deal with before but I thought that the numeric format applied to the sql results and also the numbers that you used in the sql clauses.

Regards,

Néstor Boscán