SQL* Plus exit autocommit…

In SQL* plus when user type exit it would always commit. This feature is their in all the oracle release even in 11g R2. But their is way to off the commit feature in SQL* plus.
Type SET EXITCOMMIT ON|OFF
More information about the SQL* plus here.
Advertisements

Published by

Anirban

I am software engineer by profession. Sometimes i post some topics about technology and some other topics which i find out interesting. My hobbies include watching movies,music, reading books(both technical and story books(fiction only)).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s