What is select statement to spell out SALARY?(Query should work upto 5 million)

Showing Answers 1 - 7 of 7 Answers

dev

  • Sep 12th, 2006
 

This will work upto 1 million:

Try this:

SQL> select to_char(to_date(1234567,'j'),'jsp') from dual;

TO_CHAR(TO_DATE(1234567,'J'),'JSP')
---------------------------------------------------------------------
one million two hundred thirty-four thousand five hundred sixty-seven

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions