sql语句查询 有一个菜单有个字段是1,2,3,4,5,6,这是一级菜单,1,2,3,4,5 这五个是1下面的子菜单 1,2,3,4这是2下面的子菜单,以此类推,把这些菜单都查出来,显示在一个树形列表的SQL语句怎么写呀 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from users start with parentid = 1 connect by prior id = parentid SELECT substr(SYS_CONNECT_BY_PATH(ename, '>'),2) "Path" FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; 得到的结果:KINGKING>JONESKING>JONES>SCOTTKING>JONES>SCOTT>ADAMSKING>JONES>FORDKING>JONES>FORD>SMITHKING>BLAKEKING>BLAKE>ALLENKING>BLAKE>WARDKING>BLAKE>MARTINKING>BLAKE>TURNERKING>BLAKE>JAMESKING>CLARKKING>CLARK>MILLER select id , connect_by_root parentid parentid from teststart with parentid in (select parentid from test) connect by prior id = parentid 分页查询的细节,都需要两次查询吗? oracle存储过程请教 oracle调优 在linux上连windows上的oracle,连不上,求助啊!!! 数据抽取问题,需立即解决,特向高手求助! 请问哪有 Oracle Application Express 的下载? 在oracle中动态sql语句如何执行? 请大家看看这个查询语句为什么这么慢? 求一个简单的算法,写一个函数,返回出3个时间段的交集! 再PL/SQL中,怎样获取指定日期加上定的天数后的新日期? =====求一个复杂的SQL语句或存储过程,谢谢啦,大神们====== Oracle两表关联,这问题怎么解决?(简单)
select *
from users start with parentid = 1
connect by prior id = parentid
FROM scott.emp
START WITH ename = 'KING'
CONNECT BY PRIOR empno = mgr; 得到的结果:
KING
KING>JONES
KING>JONES>SCOTT
KING>JONES>SCOTT>ADAMS
KING>JONES>FORD
KING>JONES>FORD>SMITH
KING>BLAKE
KING>BLAKE>ALLEN
KING>BLAKE>WARD
KING>BLAKE>MARTIN
KING>BLAKE>TURNER
KING>BLAKE>JAMES
KING>CLARK
KING>CLARK>MILLER
select id , connect_by_root parentid parentid from teststart with parentid in (select parentid from test) connect by prior id = parentid