Oracle - Convert Character Strings to Numbers in Oracle

Convert Character Strings to Numbers in Oracle

Q

How To Convert Characters to Numbers in Oracle?

✍: FYIcenter.com

A

You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples:

SELECT TO_NUMBER('4123.4570') FROM DUAL
4123.457

SELECT TO_NUMBER('     $4,123.46','$9,999,999.99') FROM DUAL
4123.46

SELECT TO_NUMBER(' -4.12E+03') FROM DUAL
-4120

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 551👍, 0💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3833👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 733👍, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Query with a Left Outer Join in Oracle
How To Write a Query with a Left Outer Join in Oracle? If you want to query from two tables with a left outer join, you can use the LEFT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a left outer join from two tables: departments and employees. The join conditi... 2019-10-18, 553👍, 0💬

Query with a Full Outer Join in Oracle
How To Write a Query with a Full Outer Join in Oracle? If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two tables: departments and employees. The join conditi... 2019-10-18, 550👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.