From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using TO_CHAR to convert numbers

Using TO_CHAR to convert numbers - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Using TO_CHAR to convert numbers

“

- [Instructor] We can use the TO_CHAR function to convert a number into a string and give it a specific format. So for example, if I'll type SELECT TO_CHAR, salary, which is the salary column from my employees table and specify the following format string as the second argument for my TO_CHAR function, the output of data from my table will look as follows. Note that using this format string formatted the number output into a more readable string representation of that number that better represents salaries. That's because the L character you see here represents local currency as configured in my database. And the combination of numbers and letters represent the formatting mask on how to format the data returned from the database. Note what happens if I remove the L character and run my query again. I still got my numbers formatted as strings but without the currency symbol. Note the difference between this method of formatting numbers to be displayed as part of my single query and…

Contents