%EXCEUTE在一个SQL Action里执行多条SQL语句

来源:互联网 发布:手机淘宝招牌尺寸 编辑:程序博客网 时间:2024/06/05 01:09

Example: Scenario1:
Open one SQL Action.............

%EXECUTE (/)
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
/
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
/
DELETE PS_JOB WHERE ROWNUM=10;
Note: Here forwardslash is optional to commit the statment.

Scenario2:
%EXECUTE()
UPDATE PS_JOB SET NAME='PEOPLESOFT' WHERE NAME1='HRMS';
COMMIT;
INSERT INTO PS_JOB VALUES('NAME','EMPID','HOME',................);
COMMIT;
DELETE PS_JOB WHERE ROWNUM=10;
COMMIT;