QUIT
The QUIT command functions the same way as the EXIT command. It terminates a SQL*Plus session and returns you to the operating system.
QUIT [SUCCESS|FAILURE|WARNING|value|user_variable|:bind_variable]
[COMMIT|ROLLBACK]where:
- SUCCESS
Returns a success status. The exact value of success is operating-system-dependent. This is the default setting, and it applies if no other return value is specified.
- WARNING
Returns a warning status. The exact value of a warning is operating-system-dependent.
- FAILURE
Returns a failure status. The value of failure is operating-system-dependent.
- value
Returns an arbitrary value as the status.
- user_variable
Returns the value of the specified user variable as the status. You can also specify SQL.SQLCODE here, to return the status of the most recently executed SQL statement.
- :bind_variable
Returns the value of the specified bind variable as the status.
- COMMIT
Causes SQL*Plus to automatically commit before exiting.
- ROLLBACK
Causes SQL*Plus to automatically roll back any open transaction before exiting.
Get Oracle SQL*Plus: The Definitive Guide 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.
