oracle通过游标方式删除所有以NO开头的session

declare

cursor cur_sess is

select sid, serial#

from v$session

where

username like 'NO%';

w_sid number;

w_serial number;

begin

open cur_sess;

loop

fetch cur_sess into w_sid,w_serial;

if cur_sess%notfound then

exit;

end if;

execute immediate 'alter system kill session '''||w_sid|| ', '||w_serial|| '''';

end loop;

end;

作者 576017120