connect by -- return top root

From: <redrobin723_at_my-deja.com>
Date: Wed, 27 Sep 2000 19:08:06 GMT
Message-ID: <8qtgie$dp5$1@nnrp1.deja.com>

I need to query a table to find the top most parent_id. I only want to return the one parent_id, not the whole tree.

The table is:

inherit_object_permission

---

parent_object_id
child_object_id

My select statement is: (where i_child_id is the incoming parameter) SELECT parent_object_id INTO object_to_check   FROM inherited_object_permission
  START WITH child_object_id = i_child_id   CONNECT BY child_object_id = PRIOR parent_object_id

It returns the whole tree...
Please help!!

Thanks in advance,
-R.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 14:08:06 CDT