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