Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, vishnudas.
Asked: March 17, 2018 - 11:44 am UTC
Last updated: March 19, 2018 - 4:47 am UTC
Version: 11.2.0.1.0
Viewed 1000+ times
SQL> create table demo(ord_no number(4),division varchar2(100)); Table created. SQL> insert into demo values(1,'123456789012'); 1 row created. SQL> SQL> select * 2 from demo d, 3 table(cast(multiset(select substr(d.division,rownum*4-3,4) x from dual connect by level <= length(d.division)/4 ) as sys.odcinumberlist)); ORD_NO DIVISION COLUMN_VALUE ---------- ---------------------------------------------------------------------------------------------------- ------------ 1 123456789012 1234 1 123456789012 5678 1 123456789012 9012
A reader, March 18, 2018 - 9:12 am UTC
The Oracle documentation contains a complete SQL reference.