User Tools

Site Tools


kurs:hierachical_tree
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,

kurs/hierachical_tree.txt · Last modified: 2014/09/10 21:22 (external edit)