本文共 304 字，大约阅读时间需要 1 分钟。
BEGIN
FOR v IN (SELECT 'alter system kill session ''' || a.sid || ',' || a.serial# || ''' immediate' AS v_sqlFROM v$session aWHERE a.program in ('plsqldev.exe') ) LOOPbeginEXECUTE IMMEDIATE v.v_sql;exceptionwhen others then commit;end;END LOOP;END;/转载于:https://blog.51cto.com/12185273/2066558