-
auto commit if run sql script from unix prompt?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|