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: How to query sys tables for self-joining tables/columns?

Re: How to query sys tables for self-joining tables/columns?

From: Gene Hubert <gwhubert_at_hotmail.com>
Date: 9 Aug 2001 11:26:56 -0700
Message-ID: <7e3fa619.0108091026.6440301@posting.google.com>

You can join any table to itself on any column but it sounds like you mean something different by "self join". If you could provide more info you might get some useful answers.

Gene Hubert
Durham, NC


"Randall J. Parr" <RParr_at_TemporalArts.com> wrote in message news:<3B707C15.A5E561F7_at_TemporalArts.com>...
> Is it possible, and if so how, to query the system tables of 8.1.5+ to find
> tables with a self-join and the self-joining columns?
>
> Thanks
> R.Parr
> Temporal Arts
Received on Thu Aug 09 2001 - 13:26:56 CDT

Original text of this message

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