Siva Academy

Youtube.com/SivaAcademy  Oracle SQL  |  PLSQL  |  SQL PLSQL Interview Questions  |  PLSQL Scenario based Interview Questions  |  Subscriber Questions & Answers

  |  SQL practical Question  |  SQL Performance Tuning  |  New Features  |  

  Trigger     |    View  

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