Oracle Family Trees and connect by

From: <todd_at_cardinalgroup.com>
Date: Fri, 25 Feb 2000 21:52:06 GMT
Message-ID: <896ti4$b17$1@nnrp1.deja.com>

I am trying to create a hierarchical listing of parent child relationships in Oracle but there appears to be a bug that I am finding. When a connect by is done, the levels will not be in any certain order. I thought that since I was doing a connect by using particular fields that the ordering would be ascending by that connect by field. I guess not.

Any comments or suggestions would be much appreciated.

Here is the query I am doing and the output.

SQL> select LPAD('____', 4*(Level-1), '____')||journal_name as Hierarchy
  2 from journal_list
  3 where net_id = 205
  4 start with journal_name = 'Industrial Organization and Regulation'   5 connect by parent_journal_name = prior journal_name;

HIERARCHY

---

---

Industrial Organization and Regulation
____IO: Empirical Studies of Firms and Markets (Forthcoming)
________Firm Behavior (Topic)
____________Todd Test
____________Todd Test
________Imperfect Competition (Topic)
________Market Structure (Topic)
________Studies: Other (Topic)
____IO: Productivity, Innovation and Technology (Forthcoming)
________Innovation (Topic)
________Productivity (Topic)
________Technology (Topic)
________Intellectual Property (Topic)
____IO: Regulation, Antitrust and Privatization (Forthcoming)
________Antitrust (Topic)
________Regulation (Topic)
________Deregulation/Restructuring of Public Sector Firms
________Privatization and Nationalization (Topic)
____IO: Firm Structure, Purpose, Organization and Contracting
(Forthcoming)
________Governance and Ownership (Topic)
________Integration (Topic)
________Internal and External Contracting and Transaction Costs (Topic)
____IO: Theory (Forthcoming)
________Cooperation and Collusion (Topic)
________Entry and Exit (Topic)
________Theory: Other (Topic)
________Networks (Topic)
________Pricing (Topic)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 25 2000 - 15:52:06 CST