kurs:hierachical_tree
Differences
This shows you the differences between two versions of the page.
| — |
kurs:hierachical_tree [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | SQL> select lpad(' ',level*2)||parentid parentid, childid, factor | ||
| + | 2 from itemsets | ||
| + | 3 connect by prior childid = parentid | ||
| + | 4 start with parentid = 'BIKE'; | ||
| + | </code> | ||
| + | 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)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
