File Library

Bye-bye CONNECT BY - Using the New Recursive SQL Syntax
Topic: The Database
Owner: Dominic Delmolino
Date: 2013-05-27
Subtopic: Tips and Techniques

Hierarchical queries in Oracle have always been a challenge, even for advanced SQL practitioners, with Oracle-specific SQL language elements which are not part of the SQL standards. Beyond the SQL-92 standard, the ANSI SQL:1999 standard added the definition of a recursive query which has now been adopted by Oracle. In this presentation, we'll talk about how to translate common CONNECT BY statements and use the new construct to solve more esoteric problems. The attendee will benefit by using this new standard, portable construct for hierarchical queries in Oracle and other databases.

Download File   Delmolino_hierarchical_presentation.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database