In SQL*Plus, 'exit' or 'quit' command is used to disconnect from the database and come out of the SQL*Plus prompt back to the OS prompt.
By default, exit command commits any pending transaction before exiting from the SQL*Plus session.
This can be controlled by the SQL*Plus setting 'EXITCOMMIT', which is ON by default. This means any pending transaction is committed when you use the exit command in SQL*Plus.
You also can provide option to exit command such as commit or rollback.
'exit commit' will commit any pending transaction and 'exit rollback' will rollback any pending transaction before exiting from SQL*Plus session. The 'EXITCOMMIT' setting value is ignore in this case.
Watch the below video for a detailed tutorial & demo on this topic.
=======================================================================
** Email to info@shreyantech.com to get the Tip of the Day in your mailbox.
No comments:
Post a Comment