Cancel executing query programmatically

[anandkl]

If your using scripts then u can kill the script

kill -9 scriptname

Or kill the session

alter system kill session 'sid,serial#';

regards
anandkl