MAXIMO批量删除应用程序

MAXIMO批量删除应用程序

1. declare
2. cursor c_data is
3. select * from maxapps
4. where description in ('卷包点检汇总表','动力工单汇总查询','设备运行汇总');
6. c_row c_data%rowtype;
7. begin
8. for c_row in c_data loop
9. delete from maxapps where app=c_row.app;
10. delete from maxpresentation where app=c_row.app;
11. delete from sigoption where app=c_row.app;
12. delete from applicationauth where app=c_row.app;
13. delete from maxlabels where app=c_row.app;
14. delete from maxmenu where moduleapp=c_row.app and menutype !='MODULE';
15. delete from maxmenu where moduleapp=c_row.app and elementtype='APP' and keyvalue=c_row.app;
16. end loop;
17. end;

转载于:https://www.cnblogs.com/zgray/p/3311133.html