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 | SQL & Data Engineering | 💻 Oracle * Snowflake * PostgreSQL * Mysql * MongoDB | 🎯 Interview Prep & Practical Learning | 👇 Tutorials & Courses
No comments:
Post a Comment