Question

Which statement will return the salary (for example, the salary of 6000) from the employees table in the following format? $6000.00?

Answer 1

The answer is as given below:

SELECT TO_CHAR(salary, '$99999.00') SALARY FROM employees

In this case, the TO_CHAR inbuilt function takes the value of ‘SALARY’ from the table employees and converts it to the $99999.00 string format. The resultant value is then assigned to the field ‘salary’.