- Oracle SQL*Plus: The Definitive Guide
- Preface
- 1. Introduction to SQL*Plus
- 2. Interacting with SQL*Plus
- 3. Generating Reports with SQL*Plus
- Following a Methodology
- Saving Your Work
- Designing a Simple Report
- Advanced Report Formatting
- Totals and Subtotals
- Other Reporting Topics
- 4. Writing SQL*Plus Scripts
- Why Write Scripts?
- Using Substitution Variables
- Prompting for Values
- Cleaning Up the Display
- Packaging Your Script
- The DEFINE and UNDEFINE Commands
- Controlling Variable Substitution
- Commenting Your Scripts
- 5. Extracting and Loading Data
- 6. Exploring Your Database
- 7. Advanced Scripting
- 8. Tuning and Timing
- 9. The Product User Profile
- 10. Administration with SQL*Plus
- 11. Customizing Your SQL*Plus Environment
- SQL*Plus Settings You Can Control
- The Site and User Profiles
- Environment Variable Settings
- The SET Command
- The SHOW Command
- A. SQL*Plus Command Reference
- SQLPLUS
- Comment Delimiters (/*...*/)
- Double Hyphen (- -)
- At Sign (@)
- Double At Sign (@@)
- Forward Slash (/)
- ACCEPT
- APPEND
- ARCHIVE LOG
- ATTRIBUTE
- BREAK
- BTITLE
- CHANGE
- CLEAR
- COPY
- COLUMN
- COMPUTE
- CONNECT
- DEFINE
- DEL
- DESCRIBE
- DISCONNECT
- EDIT
- EXECUTE
- EXIT
- GET
- HELP
- HOST
- INPUT
- LIST
- PASSWORD
- PAUSE
- PROMPT
- QUIT
- RECOVER
- REMARK
- REPFOOTER
- REPHEADER
- RUN
- SAVE
- SET
- SHOW
- SHUTDOWN
- SPOOL
- START
- STARTUP
- STORE
- TIMING
- TTITLE
- UNDEFINE
- VARIABLE
- WHENEVER
- B. SQL*Plus Format Elements
- Index
- Colophon
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
- ROLLBACK
Causes SQL*Plus to automatically roll back any open transaction before exiting.
-
No Comment