Oracle从1977年的雏形成长到现在已经32岁了，她是相当的聪明可人，您看，她都会数数了。
看一下TO_DATE和TO_CHAR函数“混合打法”能给我们带来怎样的神奇。

1.“一”的发音
sec@ora10g> col count_number for a60
sec@ora10g> select to_char(to_date(1,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
ONE

2.“二十二”的发音
sec@ora10g> select to_char(to_date(22,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
TWENTY-TWO

3.“三百三十三”的发音
sec@ora10g> select to_char(to_date(333,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
THREE HUNDRED THIRTY-THREE

4.“四千四百四十四”的发音
sec@ora10g> select to_char(to_date(4444,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
FOUR THOUSAND FOUR HUNDRED FORTY-FOUR

5.“五万五千五百五十五”的发音
sec@ora10g> select to_char(to_date(55555,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
FIFTY-FIVE THOUSAND FIVE HUNDRED FIFTY-FIVE

6.“六十六万六千六百六十六”的发音
sec@ora10g> select to_char(to_date(666666,'J'), 'JSP') as count_number from dual;

COUNT_NUMBER
------------------------------------------------------------
SIX HUNDRED SIXTY-SIX THOUSAND SIX HUNDRED SIXTY-SIX

……

7.小结
毕竟是位“美国丽人”，目前只会说英语，也许再过几年她就会讲中文了。

Good luck.

secooler
09.12.10

-- The End --

ITPub博客

【Tip】使用TO_DATE和TO_CHAR函数让Oracle自己去数数

最新文章