DylanSun's Blog

dylan@DYLAN11> create table seg_test( x int primary key, y varchar2(20)); Table created. dylan@DYLAN11> select owner,header_file,header_block,bytes,blocks,extents from dba_segments where seg

在Oracle 11gR2之前，一般用start with和connect by来递归的显示树形结构，请看如下脚本   select lpad(' ',2*level-1,' ') || ename ename,empno,mgr     from emp     where empno is not null     connect by prior empno = mgr