Database Answers Header Steps in Peacocks Pond, Florida, courtesy Robert Smith, Australia
Hierarchies
Home Ask a Question FAQs Data Models Search Site Map  
  • A (Dezign) Data Model is shown below and An Access Database is available on request.

    DESIGN NOTES :-
    The design is very simple. Unfortunately, the SQL to retrieve a hierarchy is not so simple.
    The best approach is to use SQL Views to define the layout that you want to display. Oracle has provided an extension to SQL called CONNECT BY.
    Joe Celko has a comprehensive discussion in Chapter 26 on 'Trees' in his book 'SQL for Smarties' (5 Stars on Amazon).

    Dezign Data Model for Hierachies

    • Barry Williams
    16th. November 2002
    Principal Consultant
    Database Answers

    [ Home Page | Ask Us a Question | Email Us | Site Map ]
    © DataBaseAnswers.com 2002