Expected Output:
with d as (select ename c FROM emp where deptno=20)
select listagg(substr(c,l,1),' ') within group(order by l) result from d,
lateral(select level l from dual connect by level <=length(c))
group by c;
select regexp_replace(ename ,'(.)','\1 ') col FROM emp where deptno=20;
S M I T H
J O N E S
S C O T T
A D A M S
F O R D
No comments:
Post a Comment