To_char Function in sql, Convert Numbers Into words

1.Create a query that displays the employees ’ last names and commission amounts. If anemployee does not earn commission, show  “No Commission.” Label the column   COMM

Query is as follows

SQL> SELECT last_name,
NVL(TO_CHAR(commission_pct), 'No Commission') COMM
FROM employees;

2. How to convert number into words
Example :-

 SELECT TO_CHAR (TO_DATE (260050, 'j'), 'jsp') FROM DUAL;


SQL> /

TO_CHAR(TO_DATE(260050,'J'),'JSP
--------------------------------
two hundred sixty thousand fifty

Share this

Hemalata