Oracle user drop who is connected.

[해리]

* Sample

get kill

declare

   str     varchar2(100);

begin

   for SES in (select sid,serial# from v$session

           where username='BPR')      loop

           str := 'alter system kill session '||chr(39)||SES.sid||','||SES.serial#||chr(39);

           execute immediate str;

   end loop;

end;

/

drop user BPR cascade;