事务的例子.docVIP

事务操作的例子 一、创建数据表 drop sequence person_seq; CREATE SEQUENCE person_seq INCREMENT BY 1 START WITH 10000 NOMAXVALUE NOCYCLE CACHE 10; drop table PERSONS; create table PERSONS( ID NUMBER not null, NAME VARCHAR2(50), AGE NUMBER, SEX VARCHAR2(50), constraint ID primary key (ID) ); insert into persons(ID, Name,Age,Sex) values( person_seq.nextval, zhangsan, 32,male); insert into persons(ID, Name,Age,Sex) values( person_seq.nextval, lisi, 32,male); insert into persons(ID, Name,Age,Sex) values( person_seq.nextval, wangw