I'm having trouble converting a varchar2 field to a currency field in Oracle.
Field1 = 050
Field2 = 1099
I want it to return 0.50! How do I accomplish this?
I want it to return 10.99! How do I accomplish this?