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)