Tuesday, October 30, 2012

Revert string with SQL

SELECT LISTAGG (
                 SUBSTR('&str', level, 1)
                 ,''
               )
       WITHIN GROUP (ORDER BY level DESC) 
FROM DUAL
CONNECT BY LEVEL <= LENGTH('&str');

No comments:

Post a Comment