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
(
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