varchar to Number with TO_NUMBER() function!
560007Mar 21 2007 — edited Mar 21 2007Hello,
Im trying to convert a string to a number, i know it must be very simple but i cant figure out the right syntax.
im trying it like this:
matchums.PROV_GRUNDLAGE:= TO_NUMBER(rechnungsaus.PROV_GRUNDLAGE,10.2);
-- rechnungsaus.PROV_GRUNDLAGE is a varchar2(30)
-- matchums.PROV_GRUNDLAGE is number(10,2)
How do i convert this string the easiest way??
thanks for help!
Phil