SQL & PL/SQL Colletions
SELECT REGEXP_SUBSTR(99999.0123456789, '[[:digit:]]+$')FROM DUAL
--------------------------------------------------------------------------------SELECT REGEXP_SUBSTR(TO_CHAR(99999.0123456789,'999999999.9999999999'), '[[:digit:]]+$')FROM DUAL
Post a Comment
No comments:
Post a Comment