Re: [indo-oracle] Re: insert comma

[Awaluddin Hamid]

Pesex NET Company wrote:
>  
>
>
> dicoba gini bisa g?
>
> > SQL> insert into test values ('20',' 20,1') ;
> > insert into test values ('20', '20,1')
>
>


Bisa aja, asal default separator desimalnya adalah "," (koma). Jika 
tidak, harus di-alter dulu biar inputan yg menggunakan desimal separator 
"," bisa divalidasi.
SQL> ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';
Session altered.
SQL> INSERT INTO test VALUES (20, '20,1');

CMIIW,
AH