--序列和表是平级的
--创建序列
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
--创建序列
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