how to convert a number in to words
suppose 1234 which will gives one thousand two hundred thirty four
through a sql query
and how the functionality works
2007-02-18 12:11:35 · 5 answers · asked by sree 1 in Computers & Internet ➔ Programming & Design
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650
2007-02-18 13:58:30 · answer #1 · answered by Anonymous · 1⤊ 2⤋
Many people do it by means of pure SQL on SQL Exercises.
2007-02-19 03:42:53 · answer #2 · answered by Serge M 6 · 0⤊ 0⤋
I do it with this, slightly different to Manit's
select to_char(to_date(999, 'J'),'JSP') from dual
where 999 is replaced with the number or column to be converted.
2007-02-19 12:05:17 · answer #3 · answered by Elizabeth Howard 6 · 0⤊ 0⤋
you can use following SQL to do tha..
select to_char(to_date('<
Give the number you want to spell out.
but this sql will work for any number b/w 1 to 5373484.
Cheers!!!!!!!!
2007-02-19 09:28:57 · answer #4 · answered by Manit 1 · 1⤊ 0⤋
select do, your, own from homework
where plagiarism = wrong;
You'd never do this in pure SQL IRL, this would be done at the application level.
2007-02-18 20:17:42 · answer #5 · answered by Vegan 7 · 2⤊ 4⤋