Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Please help.Decimal(19,4)

542647Mar 15 2007 — edited Mar 16 2007
Hi,I am updating a column with decimal(19,4) as datatype,When i am giving below mentioned command it is pausing there without succedding ot giving any error
update CHIXFILEStatus
SET
mRejectTotal = Cast('$10,000.00' as decimal(19,4))
Where sFileName = 'cXf_110015008_05092006_130501_00_0000000007';
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2007
Added on Mar 15 2007
5 comments
279 views