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 REGEXP_SUBSTR('An example sentence.', '.*', 1, level) AS parts FROM dual CONNECT BY REGEXP_SUBSTR('An example sentence.', '.*', 1, level) IS NOT NULL;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear