oracle语句及回滚语句

DML语句：

update test.Persons set lastname='huarong' where PERSONID=1;

update test.Persons7 set lastname='huarong' where PERSONID=1;

回滚语句：

update test.Persons set lastname=‘fang’  where PERSONID=1

update test.Persons7 set lastname=‘fang’  where PERSONID=1

DDL语句

CREATE TABLE test.boy(

PersonID int,

LastName varchar(255),

FirstName varchar(255),

Address varchar(255),

City varchar(255)

);

Alter table test.boy add child char(20);

回滚语句：

DROP TABLE test.boy;

alter table test.boy drop column child;

DML：

insert into "TEST"."PERSONS" ( "LASTNAME", "FIRSTNAME", "CITY", "ADDRESS", "PERSONID") values ( :1, :2, :3, :4, :5) returning ROWID into :NAV_ROWID

update base.bs_static_data set static_data_value where static_data_id in(223,224)