SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
/* with tb as (select 'test' as c1, 'tert' as c2 from dual) select regexp_substr(c1, '[^,]+', 1, rownum) SPLIT from tb connect by level <= length (regexp_replace(c1, '[^,]+')) + 1) select regexp_substr('SMITHALLENWARDJONES','[^,]+', 1, level) as split from dual connect by regexp_substr('SMITHALLENWARDJONES', '[^,]+', 1, level) is not null; */ select trim(regexp_substr('1$03453645570213$034005376924$0340002208520191202134$036','[^$]+', 1, level) ) value, level from dual connect by regexp_substr('103453645570213$034005376924$0340002208520191202134$036', '[^$]+', 1, level) is not null order by level;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear