TO_NUMBER #

Functionality:#

This Oracle function converts a string to a number

Parameters:#

NUMBER	the text string
Format	(optional) the format that the string is in – generally not used

Returns: #

Number

Errors: #

None

Operations: #

This function is when Oracle (which normally does conversions for you automatically) needs guidance to convert numbers from text for arithmetic operations. You may find this needed to do numeric (rather than text) comparisons of values. It is recommended that you do explicit data conversions as you may get unexpected results when allowing Oracle's implicit conversion to take place.

Example:#

to_number(~)|| will return 123.55 when the value is ‘123.55’

---

Notes #

Click to create a new notes page