Chesson's PeopleSoft Blog

Focus on Oracle Application

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

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;

posted on 2012-01-12 21:44  chesson  阅读(475)  评论(0编辑  收藏  举报