Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Big Problem !
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.ORGReceived on Thu Jan 13 2005 - 08:49:20 CST
![]() |
![]() |