2.4. Disconnecting

There is a difference between “disconnecting from the database” and exiting the SQL*Plus application. When you use the EXIT command:

  1. Any database changes you submitted, such as INSERT statements, are committed; that is, they are permanently applied to the database. This is because SQL*Plus does an implicit commit when you end your session.

  2. Your point-to-point session is terminated.

  3. Finally, your SQL*Plus program exits and you are back to your desktop or command shell.

From within SQL*Plus, you do have the option to just DISCONNECT from your current database connection but keep the SQL*Plus application up. When you disconnect:

  1. Any database changes you submitted, such as INSERT statements, are committed; that is, they are permanently ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial