oracle简单序列,oracle中简单的sql执行的表、序列、触发器

--创建表

create table position ( id number(10) not null

primary key , deviceName varchar2(30) )

--创建序列

create sequence position_seq start with 1 increment by 1

minvalue 1 maxvalue 9999999 nocycle nocache noorder;

--创建触发器

create or replace trigger position_trigger before insert on

position for each row begin select position_seq.nextval into:new.id

from sys.dual; end;

--插入语句

insert into position(id,deviceName)

values(position_seq.nextval,'aaa')

--查询语句

select * from position

--清空表中的数据(速度很快)

truncate table position

--删除序列

DROP SEQUENCE position_seq;