| sql scripts on unix [message #32569] |
Wed, 25 August 2004 11:00  |
chetna
Messages: 21
Registered: July 2004
|
Junior Member |
|
|
Friends,
When we do updates and inserts with sql statements (Oracle) from unix shell scripts, is there an auto commit on ?
I have observed that even though i don't put an explicit "commit" statement after the update/delete/insert statements, they seem to be committed automatically.
How does this work technically ? is this related to sql session (Oracle) itself , or does the unix session ?
thanks a bunch
chetna
|
|
|
|
| Re: sql scripts on unix [message #32571 is a reply to message #32569] |
Wed, 25 August 2004 11:45  |
shoblock
Messages: 325
Registered: April 2004
|
Senior Member |
|
|
|
It's a sqlplus thing, not unix, oracle, or sql (sql is a language, sqlplus is a tool to interface with oracle and parse/execute sql). Sqlplus does a commit on exit, so if exit without rolling back or committing, it commits for you.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
