oralce 9.2.0.1.0的bug还真多

SQL> select * from a;

         A          B C
---------- ---------- ----------
         1          1 c1
         2          1 c2
         3          2 c3
         4          2 c9
         5          2 c5

SQL> select b,
  2   substr(max(sys_connect_by_path(c,'/')),2,
  3                LENGTH(max(sys_connect_by_path(c,'/')))) path
  4  from (select a,b,c,lead(a) over (partition by b order by a desc) d from a)
  5  start with d is null
  6  connect by prior a = d
  7  group by b;
select
*
ERROR 位于第 1 行:
ORA-03113: 通信通道的文件结束