Topic: Sorting of the field received as WAY = SYS_CONNECT_BY_PATH (prev, ' / ')
Field WAY = SYS_CONNECT_BY_PATH (prev, ' / ') - so it has been really generated. Only them it turned out... With cyclical swaps from a tree.
I want to arrange this field, that then .
select dd. *, RegExp_substr (dd.way, ' [^/] + ', 1, level) as str from ( select 6 as n, '/6/3/2/5/9/7/8/4 ' as way from dual union select 5 as n, '/5/9/7/8/4/6/3/2 ' as way from dual ) dd connect by RegExp_substr (dd.way, ' [^/] + ', 1, level) is not null
However for single line produces the necessary 9 lines, and for 2 (as in an example) them 510 though expected 18.
I do not understand why so much? Like even 510 = 3*17*10 not with 9*9.
The field length is in advance unknown.