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,