Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help with hierarchical query
Google "transitive closure oracle"
"Ronnie" <ronnie_yours_at_yahoo.com> wrote in message
news:ea603f8d.0407091134.466b258b_at_posting.google.com...
> Hi,
>
> I have a table with sample records as below
>
> Parent Region Child Region
> ============= ============
> North America USA
> USA CALIFORNIA
> USA CONNECTICUT
> CALIFORNIA ORANGE COUNTY
> CONNECTICUT FAIRFIRLD COUNTY
> FAIRFIELD COUNTY NORWALK
>
> I want to create a flattened table / materialized view such as below
>
>
> Parent Region Child Region
> ============= ============
> North America USA
> North America CALIFORNIA
> North America CONNECTICUT
> North America ORANGE COUNTY
> North America FAIRFIELD COUNTY
> North America NORWALK
> USA CALIFORNIA
> USA CONNECTICUT
> USA ORANGE COUNTY
> USA FAIRLFIELD COUNTY
> USA NORWALK
> CALIFORNIA ORANGE COUNTY
> CONNECTICUT FAIRFIELD COUNTY
> CONNECTICUT NORWALK
> FAIRFIELD COUNTY NORWALK
>
> I am at loss as to how do I write a query to do this. I can do it by
> writing a stored procedure but was thinking whether its poccible using
> connect by in a single query to achieve this.
>
>
> Thanks
> Ron
Received on Fri Jul 09 2004 - 15:18:32 CDT