Hi,

If I have a sql script that has something like below and without exit at the end:

=================================
spool filename
select . . .
from . . .
where . . .
/

update . . .
set . . .
where . . .
/

select . . .
from . . .
where . . .
/

spool off
==============================

I run the script as "sqlplus -s username/password @filename.sql" from UNIX command line. Then I press ctrl+C to exit the process as it fails to go back to UNIX prompt due to no "exit" at the end of sql script. Does it do auto commit even though we don't specify commit in the script after update statement? For some reason it does. I thought it should rollback because I do force exit the process.

Thanks.