<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
&nbsp; &nbsp; &nbsp; I have a field on Oracle Report and i need format to number a string field, &nbsp;that is the code:<br />
<br />
function CF_1FORMULA0045 return Char is<br />
begin<br />
&nbsp; if ((:monto_total)= 0) then<br />
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return('');<br />
&nbsp; ELSE<br />
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURN(SELECT TO_NUMBER(:MONTO_TOTAL) FROM DUAL);<br />
&nbsp; end if; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
end;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; the field MONTO_TOTAL must be formating to similar this number &nbsp; &nbsp; 12,987,456.89, &nbsp; the problem is what this field is a String Field<br />
<br />

</div>
</div>


Hi experts,

      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
begin
  if ((:monto_total)= 0) then
  	return('');
  ELSE
  	RETURN(SELECT TO_NUMBER(:MONTO_TOTAL) FROM DUAL);
  end if;	 
end;
                    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



how i do a format string field on Oracle Report to number?

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.