Child to Parent

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Thu, 14 Jun 2001 23:13:51 -0700
Message-ID: <F001.0032ACFF.20010614222548@fatcity.com>

Dear List,

I need some info, I have a table where I store the details of dealers in the table.

structure is

SF_DEALER_CODE                            NOT NULL VARCHAR2(10)
SF_DEALER_NAME                                     VARCHAR2(40)
SF_CIRCLE_CODE                            NOT NULL VARCHAR2(10)
SF_AREA_OF_OPERATION                      NOT NULL VARCHAR2(10)
SF_DEALER_TYPE                            NOT NULL VARCHAR2(1)
SF_PARENT_DEALER                          NOT NULL VARCHAR2(10)

In the same table itself i store both parent and child recs. Is there any way to trace the parent from child. If want to trace the child from parent I use the prior,connect and level in my query and get the correct results. I want the reverse. Is there any way out.

Pl help.

Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: C.S.Venkata Subramanian
  INET: csvenkata_at_lycos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 15 2001 - 01:13:51 CDT