create table prior_table
(
id char(5) primary key,
name varchar2(20),
p_id char(5)
);
insert into prior_table(id,name,p_id)values('00001','qwqe1','');
insert into prior_table(id,name,p_id)values('00002','qwqe2','');
insert into prior_table(id,name,p_id)values('00003','qwqe3','');
insert into prior_table(id,name,p_id)values('10001','qwqe4','00001');
insert into prior_table(id,name,p_id)values('10002','qwqe5','00002');
insert into prior_table(id,name,p_id)values('10003','qw......
阅读全文