brianlange Posted September 6, 2011 Share Posted September 6, 2011 Does Oracles CONNECT BY work by issuing a loop? I am trying to understanding the following query SELECT TRIM(SUBSTR(txt, INSTR(txt, ',', 1, level) + 1, INSTR(txt, ',', 1, level+1) - INSTR(txt, ',', 1, level) -1)) as token, level FROM (SELECT ','||:arg1||',' txt FROM dual) CONNECT BY <= length(:arg1) - length(replace(:arg1,',',''))+1 ) If arg1 is a comma delimited list there will be returned a record set with the number of records equal to the items in the command delimited list. Can someone explain in simple terms what connect by does? Link to comment https://forums.phpfreaks.com/topic/246579-oracles-connect-by/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.