Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata