BEGIN
FOR CUR_REC IN (select ss.username,ss.terminal,ss.sid,ss.serial#,ss.inst_id from gv$session ss where module='PL/SQL Developer') LOOP
BEGIN
EXECUTE IMMEDIATE 'alter system disconnect session''' || CUR_REC.sid || ',' || CUR_REC.serial# || ',@' || CUR_REC.inst_id || ''' immediate';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END LOOP;
END;
/
No comments:
Post a Comment