oracle 高级SQL总结

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.