今天一同事给我一段PL/SQL,这可是我第一次看到这东西,原来写菜单的SQL语句
结果:SELECT DISTINCT * FROM SYS_FUNCLIST WHERE CDH ='2' AND SFXS='1'
CONNECT BY PRIOR GNBH=SUBSTR(GNBH,1,LENGTH(GNBH)_2)
START WITH GNBH IN (SELECT GNBH FROM SYS_FUNLIST WHERE CDH='2' AND SFXS ='1')
ORDER BY GNBH
在网上找的一些东西,但没有我想知道的结果,这段日志我还未完成,这东西是拿来干什么的??
待续: