ÐòÁУºoracle¿ÉÒÔͨ¹ýÐòÁÐÀ´Éú³ÉÖ÷¼ü

1. ´´½¨ÐòÁÐ

create table Foo (

foo_id number(11),

foo_value varchar2(50),

constraint FOO_PK primary key(foo_id)

)

´´½¨ÐòÁÐDDL

create sequence ÐòÁÐÃû

[ start with ÊýÖµ£¨10000£©]

[increment by ÊýÖµ]

ɾ³ýÐòÁÐDDL

drop sequence ÐòÁÐÃû

2. ²é¿´ÐòÁÐ

ͨ¹ýαÁÐcurrval»ñÈ¡µ±Ç°ÐòÁÐÖµ

ͨ¹ýαÁÐnextvalÈ¡ÐòÁÐÖµÏÂÒ»¸öÖµ

select seq_foo.nextval from dual;

select seq_foo.currval from dual;

3. ʹÓÃÐòÁÐ×÷ΪÖ÷¼ü

insert into foo (foo_id,foo_value) values(seq.foo.nextval,¡®clark¡¯);