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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Big Problem !

Oracle Big Problem !

From: Joshua Lool <josh1977_at_libero.it>
Date: Thu, 13 Jan 2005 14:49:20 +0000 (UTC)
Message-ID: <5e5f6ab0ff220ed326411d4835e524b5.84112@mygate.mailgate.org>


Hi,
I'm haveing some problem with Oracle Sql.

I'm in this situation :

---Table FATHERSON---

FATHER ---- SON

A           B
A           C
C           D
C           E
E           F
G           I
G           C


I need to return, for example, only the sons starting from C :

C           D
C           E
E           F


I use Oracle 9 and I know that there's the function CONNECT BY PRIOR but it doesn't work in my case because I undestood it needs a primary unique key and in my case it's impossible.

Can someone help me ?

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Thu Jan 13 2005 - 08:49:20 CST

Original text of this message

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