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)
SQL & PL/SQL Colletions
SELECT REGEXP_SUBSTR(99999.0123456789, '[[:digit:]]+$')
FROM DUAL
--------------------------------------------------------------------------------
SELECT REGEXP_SUBSTR(TO_CHAR(99999.0123456789,'999999999.9999999999'), '[[:digit:]]+$')
FROM DUAL