select SYS_CONNECT_BY_PATH(ename, '-')
from emp
where eno=4
connect by prior eno = mgr
start with eno =1
from emp
where eno=4
connect by prior eno = mgr
start with eno =1
解决方案 »
- plsql deveploer软件奇怪问题
- 多表数据合同
- 关于自我连接中的 on 和 where
- 在oracle10g的pro*c/c++中从c变为c++时的错误
- 大家看看,怀疑和Oracle的字符集相关
- 菜鸟提问:如何创建一个表B和表A一模一样?语句怎么写?
- 如何对除以table_开头的表以外的所有表赋select权限啊?
- 求助!!!!!!!!
- 存储过程中有字符串 str := 'select * form a where id=‘10101’'如何在其中加入引号
- 存储过程中声明二维数组实现,入参是一条记录(可能有语病),出参是整个一个结果集
- bobfang(匆匆过客)还在吗?还是触发器中一个语句问题得不到解决,请教各位大狭.
- oracle 的权限问题
from emp
where eno=4
相当于你说的“ end with ”
FROM emp1
WHERE INSTR ((SELECT SYS_CONNECT_BY_PATH (ename, '/')
FROM emp1
WHERE eno = 4
CONNECT BY PRIOR eno = mgr
START WITH eno = 1), ename) > 0
CONNECT BY PRIOR eno = mgr
START WITH eno = 1
SELECT LEVEL, eno, ename
FROM emp
WHERE INSTR ((SELECT SYS_CONNECT_BY_PATH (ename, '/')
FROM emp
WHERE eno = 4
CONNECT BY PRIOR eno = mgr
START WITH eno = 1), ename) > 0
CONNECT BY PRIOR eno = mgr
START WITH eno = 1
from emp
start with ename='dd'
connect by prior mgr=eno;