SQL> select lpad(' ',level*2)||parentid parentid, childid, factor 2 from itemsets 3 connect by prior childid = parentid 4 start with parentid = 'BIKE'; http://asktom.oracle.com/pls/ask/f?p=4950:8:11487139311894754233::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4274185613870,