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 -> Recursive select

Recursive select

From: <buurd_at_my-deja.com>
Date: Thu, 18 Nov 1999 15:39:59 GMT
Message-ID: <8116k5$sf9$1@nnrp1.deja.com>


 Hi... i want to ask a question like this: List all ancesters from person p. No only the closest one but ALL that is in the table. My table looks (somewhat simplified) like this

table related(
  id int,
  name varchar2(30),
  parent int
)

Tia

--
Roland Carlsson
Certified Java programmer
Skövde
Sweden

Ps: I hope the solution isn't embarresbly simple ;-)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 09:39:59 CST

Original text of this message

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