Thanks everybody (esp. Mikito)!

Using the "connect by" construct does the trick. The information about
using "connect by" talks about family tree and other hierarchies.
Basically my linked list scenario can be treated as one. It's just a
hierarchy with nodes but no branches.

Using the example that Lennart graciously provided, the Oracle version
goes like this:

To go down the list:

select id from list
start with id = 3
connect by prior id = nextid;

and up the list:

select id from list
start with id = 3
connect by id = prior nextid;

Just what I needed! Thanks again.

-Mia

"Mia" <nospam (AT) cox (DOT) net> wrote

Exactly which ID's did you want again? If you don't care about order, you
obviously can not care about the ID's in the list that come before the given
ID, because then you would be querying based on the order in the list.
Likewise, you can not care about the ID's in the list that come after the
given ID, because again that would depend only on the order of the ID's in
the list.


How can anything precede or follow without order?


If you insist.