MAXIMO批量删除应用程序

MAXIMO批量删除应用程序

declare
    cursor c_data is
    select * from maxapps
    where description in ('卷包点检汇总表','动力工单汇总查询','设备运行汇总');
    c_row c_data%rowtype;
begin
    for c_row in c_data loop
        delete from maxapps where app=c_row.app;
        delete from maxpresentation where app=c_row.app;
        delete from sigoption where app=c_row.app;
        delete from applicationauth where app=c_row.app;
        delete from maxlabels where app=c_row.app;
        delete from maxmenu where moduleapp=c_row.app and menutype !='MODULE';
        delete from maxmenu where moduleapp=c_row.app and elementtype='APP' and keyvalue=c_row.app;
    end loop;
end;