原文出处: http://blog.sina.com.cn/s/blog_694448320100kyfp.html
--创建表
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;