Oracle hierarchical queries

Marko Asplund <[email protected]> 05 May 2003 13:17:59 +0300

Newsgroups	gmane.comp.db.sapdb.sources
Organization	Kronodoc oy
Message-ID	<[email protected]>

SAP DB v7.4 does not seem to support Oracle hierarchical queries like
the following

SELECT level,parent_node_id,node_id,order_in_level FROM tree_nodes WHERE
level<500 START WITH node_id=1000 CONNECT BY PRIOR
node_id=parent_node_id

does SAP DB support hierarchical queries of any form? are there plans
for adding hierarchical query features in SAP DB?


best regards,
-- 
	aspa						http://www.kronodoc.fi/