Siva Academy
Pages
(Move to ...)
Home
SQL PLSQL Interview Questions
PLSQL Scenario based Interview Questions
▼
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
‹
›
Home
View web version
No comments:
Post a Comment