Kill session statement generate

Kill session statement generate
======================

select'alter system kill session '''||''||sid||','|| serial#||''''||';' kill_statement
from v$session
where username ='SCOTT' ---give user name
andsid=&p_sid;---give sid or omit it

__________________