Re: Populate Heirarchical tree from master detail tables?
Date: Sat, 09 Oct 2004 00:57:07 GMT
Message-ID: <Xns957CB69E867E1SunnySD_at_68.6.19.6>
sldcrew2k_at_yahoo.com (steve deno) wrote in news:8e6b14d8.0410081047.5cf6df48_at_posting.google.com:
> Sorry for cross posting but I thought maybe tools was a better place
> than server for this after the fact.
>
> All,
>
> I am building a form where a heirarchical tree control would be very
> useful. In the documentation I have looked at, they only speak of
> querying heirarchical tables with self joins. Has anyone queried
> multi-level master detail relationships in to a tree? For example, If
> I had a Houses table, a rooms table and a furniture table - for lack
> of a better example, and wanted to have a house which can be clicked
> on, showing rooms, which have furniture items underneath. Would a
> view based on these tables joined by their primary keys be usable in a
> heirarchical tree using the psuedo columns Level, etc. I need to read
> further to understand the queries, but if anyone has had experience, a
> simple example would be very helpful.
>
> Thanks very much
>
> Steve
>
Do a keyword search on CONNECT BY
http://asktom.oracle.com/pls/ask/f?p=4950:8:12673824133307485913::NO::F4950 _P8_DISPLAYID,F4950_P8_CRITERIA:11452690446345, "How to Rollup Hierarchy from CONNECT BY into Singe Row?", Received on Sat Oct 09 2004 - 02:57:07 CEST