how i do a format string field on Oracle Report to number?
Posted on 2006-06-20
I have a field on Oracle Report and i need format to number a string field, that is the code:
function CF_1FORMULA0045 return Char is
if ((:monto_total)= 0) then
RETURN(SELECT TO_NUMBER(:MONTO_TOTAL) FROM DUAL);
the field MONTO_TOTAL must be formating to similar this number 12,987,456.89, the problem is what this field is a String Field