oracle分析函数总结:
1. 树型显示
select empno,rpad('-',level-1,'-')||ename as ee,prior ename as manager,sal from emp start with mgr is null connect by prior empno=mgr;
2.
oracle分析函数总结:
1. 树型显示
select empno,rpad('-',level-1,'-')||ename as ee,prior ename as manager,sal from emp start with mgr is null connect by prior empno=mgr;
2.