Hi, On 8.1.7.2 (soon to be .3) on HP/UX 11.0, a developer needs to get the top parent associated with a lower level row. Expanding on Oracle's EMP example:
EMP MGR LEVEL King 1 Greenberg King 2 Faviet Greenberg 3 Chen Greenberg 3 Sciarra 1 Urman Sciarra 2 Popp Urman 3 Jesse Urman 3 ...I need to know that the top-level manager for "Jesse" is "Sciarra". In our live data, however, we currently have 9 levels (engineering bill-of-materials) and there is no set maximum for levels. Anyone have an idea how to return: Jesse Urman Sciarra 3 ...for this? The START WITH...CONNECT BY can only give the PRIOR manager and not the top level. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
