Kill Session for SQL ID in Oracle

Below is the sample scripts to kill session for SQL_ID in oracle database.

--- For single instance database
 SELECT 'alter system kill session '''|| SID || ',' || SERIAL# || ''' immediate ;'
FROM v$session
WHERE sql_id = '&sql_id';
 --- For RAC database
SELECT 'alter system kill session '''|| SID|| ','|| SERIAL#|| ',@'|| inst_id|| ''' immediate ;'
FROM gv$session
WHERE sql_id = '&sql_id'