Pages

Saturday, June 22, 2019

Reverse the String without using reverse function




WITH t AS (
    SELECT 'WELCOME TO SQL CLASS' d
    FROM dual
) SELECT LISTAGG(s) WITHIN GROUP(ORDER BY l DESC)
  FROM
    (
        SELECT level l,substr(d,level,1) s
        FROM t
        CONNECT BY level <= length(d)
    );

No comments:

Post a Comment