SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
with tb as (select '103453689f' as c1, '10345468' as c2 from dual) ,res1 as ( SELECT REGEXP_SUBSTR (c1, '.{1}', 1, level) AS v1, level as lv1 FROM tb CONNECT BY REGEXP_SUBSTR (c1, '.{1}', 1, level) IS NOT NULL ) ,res2 as ( SELECT REGEXP_SUBSTR (c2, '.{1}', 1, level) AS v2, level as lv2 FROM tb CONNECT BY REGEXP_SUBSTR (c2, '.{1}', 1, level) IS NOT NULL ) select lv1 as lv from res1 union select lv2 as lv from res2
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear