CREATE SEQUENCE tree_seq
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
create table tree (
id number primary key,
pid number,
name varchar2(50),
pin number
)
ALTER TABLE tree ADD CONSTRAINT FK_PARENTID FOREIGN KEY(pID) REFERENCES tree (ID);
insert into tree (id,pid,name,pin) values(tree_seq.nextval,,'根节点',1);