April 2000
Intermediate to advanced
94 pages
1h 52m
English
EXIT
EXIT [SUCCESS | FAILURE | WARNING | value | user_variable | :bind_variable] [COMMIT | ROLLBACK]
The EXIT command is used to terminate a SQL*Plus session and return to the operating system. For example:
EXIT EXIT SUCCESS EXIT FAILURE ROLLBACK
Returns a success status. This is the default.
Returns a failure status.
Returns a warning status.
Returns an arbitrary value as the status.
Returns the value of the specified user variable as the status.
SQL.SQLCODE is considered a user variable, as are all the other variables listed in Table 1.8.
Returns the value of the specified bind variable as the status.
Causes SQL*Plus to commit before exiting. This is the default.
Causes SQL*Plus to roll back any open transaction before exiting.