oracle 序列

--序列和表是平级的
--创建序列
CREATE sequence seq_num




CREATE TABLE emp
(
empno NUMBER primary key NOT NULL,
empname nvarchar2(32)
)tablespace y2165tabspace


  insert into emp values(seq_num.nextval,'开发部')
 insert into emp values(seq_num.nextval,'研发部')
  commit

  select * from emp