1. Home
  2. SQL
  3. Mastering Oracle SQL

8.5 Restrictions on Hierarchical Queries

Through Oracle8i, the following restrictions apply to hierarchical queries.

  • A hierarchical query can't use a join.

  • A hierarchical query cannot select data from a view that involves a join.

These restrictions were removed with the release of Oracle9i.



    		Mastering Oracle SQL, 2nd Edition
    		Preface
    		Chapter 1. Introduction to SQL
    		Chapter 2. The WHERE Clause
    		Chapter 3. Joins
    		Chapter 4. Group Operations
    		Chapter 5. Subqueries
    		Chapter 6. Handling Temporal Data
    		Chapter 7. Set Operations
    		Chapter 8. Hierarchical Queries
    		8.1 Representing Hierarchical Information
    		8.2 Simple Hierarchy Operations
    		8.3 Oracle SQL Extensions
    		8.4 Complex Hierarchy Operations
    		8.5 Restrictions on Hierarchical Queries
    		8.6 Enhancements in Oracle Database 10g
    		Chapter 9. DECODE and CASE
    		Chapter 10. Partitioning
    		Chapter 11. PL/SQL
    		Chapter 12. Objects and Collections
    		Chapter 13. Advanced Group Operations
    		Chapter 14. Advanced Analytic SQL
    		Chapter 15. SQL Best Practices
    		Chapter 16. XML
    		Chapter 17. Regular Expressions
    		Chapter 18. Model Queries
    		Appendix A. Oracle's Old Join Syntax
    		Colophon