How to insert a comma in VARCHAR2 field [message #375165] |
Thu, 02 August 2001 00:32 |
Amit Jain
Messages: 33 Registered: August 2001
|
Member |
|
|
I am having an amount column in a table which is of VARCHAR2 type.Now I am inserting a record in it through a JAVA file i.e query generates at runtime.Now I want that value in the above mentioned column should be entered as 16,480.92 instead of 16480.92.When i tried to insert with this format it is taking it as two different values (16 and 480.92).Anybody pls can help on this regard.This is very urgent.
|
|
|
|