Daniel,

Great idea! Thanks very much.

Mike

-----Original Message-----
From: Daniel W. Fink [mailto:[Email Address Removed] Tuesday, April 30, 2002 4:06 PM
To: LazyDBA.com Discussion
Subject: RE: Dropping global temporary tables


Mike,
I don't have a solution for the error, but here is one for the JOIN on a
CONNECT BY. Push the CONNECT BY query to an inline query. Here's an example

SELECT e.e_level,
e.ename,
e.empno,
e.mgr,
d.dname
FROM dept d,
(SELECT level e_level,
LPAD(' ',2*level-2)||emp.ename ename,
emp.empno empno,
emp.mgr mgr,
emp.deptno deptno
FROM Emp
CONNECT BY PRIOR emp.empno = emp.mgr
START WITH emp.mgr IS NULL) e
WHERE e.deptno = d.deptno;



Oracle LazyDBA home page