有点问题，请大伙帮忙看看．．

create table tree
(
  id   identify(1,1)  not null primary key,
  pid  integer,
  name varchar(50)   
);

想创建一个表，用到．identify 标识，　为何不成功，指点指点．．．



Oracle:
create table USER_TREE
(
  ID   INTEGER not null primary key,
  PID  NUMBER not null,
  NAME VARCHAR2(20)
)


create sequence User_Tree_Id

insert into USER_TREE values(USER_TREE_ID.nextVal,'123','123);
insert into USER_TREE values(USER_TREE_ID.nextVal,'456','456');

OK