数据表数据如下
authid superid
01 0
02 0
03 0
0101 01
0103 01
0102 01
0210 01
0201 02
0204 02
0301 03
0307 03
020110 0210
020101 0201
011010 0210
树的上下级不严格,如何按照以下顺序排序
即正常树显示的顺序,层次比这个更多
01 0
0101 01
0102 01
0103 01
0210 01
020101 0210
021010 0210
0310 01
02 0
0201 02
0204 02
020101 0201
03 0
0301 03
0307 03
表和数据的生成语法如下
prompt PL/SQL Developer import file
prompt Created on 2004年8月8日 by Administrator
set feedback off
set define off
prompt Disabling triggers for A...
alter table A disable all triggers;
prompt Deleting A...
delete from A;
commit;
prompt Loading A...
insert into A (A, B)
values ('01', '0');
insert into A (A, B)
values ('02', '0');
insert into A (A, B)
values ('03', '0');
insert into A (A, B)
values ('0101', '01');
insert into A (A, B)
values ('0103', '01');
insert into A (A, B)
values ('0102', '01');
insert into A (A, B)
values ('0210', '01');
insert into A (A, B)
values ('0201', '02');
insert into A (A, B)
values ('0204', '02');
insert into A (A, B)
values ('0301', '03');
insert into A (A, B)
values ('0307', '03');
insert into A (A, B)
values ('020110', '0210');
insert into A (A, B)
values ('020101', '0201');
insert into A (A, B)
values ('011010', '0210');
commit;
prompt 14 records loaded
prompt Enabling triggers for A...
alter table A enable all triggers;
set feedback on
set define on
prompt Done.