Oracle Query hierarchical relations with "connect by": Difference between revisions

From WickyWiki
Created page with "Table HIERACHY has a master and a child key and an ROOT indication (indexed) the following query will show all possible paths using master-child relations, starting in records m..."
 
m 1 revision
 
(No difference)

Latest revision as of 07:26, 5 July 2013

Table HIERACHY has a master and a child key and an ROOT indication (indexed) the following query will show all possible paths using master-child relations, starting in records marked with ROOT=1

select SYS_CONNECT_BY_PATH(MASTER, '/')
  from HIERACHY
	connect by prior CHILD = MASTER
	start with ROOT=1
  ;