oracle 递归
记录一条语句SELECT F.FUNID, F.FUNNAME, F.FUNURL, F.FUNCHILDFLAG, F.FUNSORT
FROM (SELECT *
FROM SYSFUNCTION
START WITH FUNID = 52
CONNECT BY PRIOR FUNID = FUNPARENTID
AND ENABLEFLAG = 'T'
AND ISVIEWFLAG = 'T') F
WHERE F.ENABLEFLAG = 'T'
AND F.ISVIEWFLAG = 'T'
AND F.FUNCHILDFLAG = 'T' AND (F.FUNID NOT IN (SELECT W.FUNID
FROM SYSWORKBENCH W
WHERE W.USERID = '123') )
页:
[1]