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)