Bernandas Savarimuthu
SQL & PL/SQL Colletions
Tuesday, November 25, 2014
Number to Words dynamic
SELECT CAST
(
TO_CHAR
( TO_TIMESTAMP( LPAD(ABS(TO_CHAR(num,'99')),9,'0'), 'FF9' ), 'FFSP' )
AS VARCHAR2(100)
) WORD, NUM FROM (
SELECT LEVEL NUM
FROM DUAL
CONNECT BY LEVEL <= 20)
No comments:
Post a Comment
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment