如何在oracle 8.0.5下实现对多表并集的connect by查询?
SELECT level AS depth,unitid,unitname FROM
(SELECT unitid,unitname,lunitid FROM tblunit
UNION
SELECT userid,username,ksdcode FROM tbluser)
START WITH lunitid IS NULL CONNECT BY PRIOR unitid=lunitid
上面的查询在oracle 9i下可以正常运行,如何在oracle 8.0.5下实现同样的功能?