oracle pl sql error oracle pl sql error oracle pl sql error
 

Oracle to_number Function

In pl sql Oracle, the to_number function converts a string to a number.

The syntax for the to_number function is:

to_number( string1, [ format_mask ], [ nls_language ] )

string1 is the string that will be converted to a number.

format_mask is optional. This is the format that will be used to convert string1 to a number.

nls_language is optional. This is the nls language used to convert string1 to a number.

 

 
 
 

Examples using to_number Oracle function

For example Oracle:

to_number('1210.73', '9999.99') would return the number 1210.73
to_number('546', '999') would return the number 546
to_number('23', '99') would return the number 23

Since the format_mask and nls_language parameters are optional, you can simply convert a text string to a numeric value as follows:

to_number('1210.73'') would return the number 1210.73

See also stored procedure Oracle

 
 
Oracle to_number Oracle to_number
 
     
  29-11-2006 Guida Oracle 10g
     
  30-02-2007 Oracle Server
     
  29-02-2007 Oracle Errors
Functions Oracle pl sql Functions
Delete Oracle pl sql Delete
Between Oracle pl sql Between
Check Oracle pl sql check
Count Oracle pl sql Count
Datatypes Oracle pl sql datatypes
Delete Oracle pl sql delete
Distinct Oracle pl sql distinct
Exists Oracle pl sql exists
Functions Oracle pl sql functions
Grant revoke Oracle pl sql grant revoke
Group by Oracle pl sql group by
Having Oracle pl sql having
Oracle Function in Oracle pl sql in
Indexes Indexes
Insert Oracle pl sql insert
Intersect Oracle pl sql intersect
Isnull Oracle pl sql is null
Joins Joins
Oracle to_number Oracle pl sql substr
 
Oracle Functions PLSQL  l Consulenza Software Verona  l  Siti Web Verona  l   Exceptions  l  Oracle Errors  l  Oracle Collaborations Suite  l  Products  l  Contact
Oracle errors ora