Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Join on hierarchy query using the root element possible?

Re: Join on hierarchy query using the root element possible?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 01 Oct 2004 19:36:40 +0200
Message-ID: <6b5rl0ls3uj4p68nc7ucparls9bf8r120o@4ax.com> 





On 1 Oct 2004 03:37:38 -0700, schreurs_roel_at_hotmail.com (Roel
Schreurs) wrote:



>Does something like that exist? Or does anybody know another way to

>achieve this?





Does your database have a version? The answer may be version
dependent.



Hint: connect by queries are allowed in subqueries, just transform
your join to a subquery.



--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Oct 01 2004 - 12:36:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US