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)
);
Siva Academy: Learn Oracle SQL, PL/SQL, Databases, Snowflake, ETL & AI with practical tutorials, real-world examples and interview questions.
No comments:
Post a Comment