My Oracle Support Banner

How To Generate START WITH ... CONNECT BY Clauses in ODI Integration Interfaces for Parent-Child Relationships Between Records (Doc ID 1304908.1)

Last updated on OCTOBER 27, 2023

Applies to:

Oracle Data Integrator - Version to [Release 10gR3 to 11gR1]
Information in this document applies to any platform.


The START WITH ... CONNECT BY clause can be used to select data from relational table that contain hierarchical relationships between records (usually some sort of parent -> child, manager-> employee or object -> components relationship).

For example:

How can this be designed in Oracle Data Integrator (ODI) Integration Interfaces ?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.