Write a query to insert space between each char

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