DECLARE
CURSOR KILLSESSION IS
SELECT 'alter system kill session ' || '''' || T.SID || ',' ||
T.SERIAL# || '''' TT
FROM V$SESSION T
WHERE STATUS = 'INACTIVE';
BEGIN
FOR CU IN KILLSESSION LOOP
EXECUTE IMMEDIATE CU.TT;
END LOOP;
END;
在sql中执行
CURSOR KILLSESSION IS
SELECT 'alter system kill session ' || '''' || T.SID || ',' ||
T.SERIAL# || '''' TT
FROM V$SESSION T
WHERE STATUS = 'INACTIVE';
BEGIN
FOR CU IN KILLSESSION LOOP
EXECUTE IMMEDIATE CU.TT;
END LOOP;
END;
在sql中执行