Employee table SQL question

Hello everyone:

I have an EMPLOYEE table with the following columns:

	ID, 
	NAME, 
	LOGIN *, 
	SUPERVISOR_ID **

• LOGIN is the same as SELECT USER FROM DUAL (Oracle Login); ** Supervisor_ID is the foreign key to the EMPLOYEE.ID column.

I need the simplest SQL statement or PL/SQL script to get the following:         

1. The SUPERVISOR of the EMPLOYEE who is logged in
2. That SUPERVISOR's SUPERVISOR Until we get to the head of the company whose SUPERVISOR is himself.

Please help me.
=-=-=-=-=-=-=-=-=-=-=-=-=
Cleve
e-mail: cleve_at_cbcsf.org Received on Fri Jul 11 1997 - 00:00:00 CDT