SQL Plus - (EXIT|QUIT) command

Card Puncher Data Processing

About

Commits or rolls back all pending changes, logs out of Oracle, terminates SQL*Plus and returns control to the operating system.

Syntax

{EXIT|QUIT} [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK]

where:

  • the first block [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] define the exit code that can be:
  • the second block [COMMIT|ROLLBACK] defines the transaction termination action to do.





Discover More
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Host

Host executes an operating system command without leaving SQLPlus. Enter HOST without command to display an operating system prompt and EXIT to return. On Unix system, you can use the Exclamation...
Card Puncher Data Processing
SQL Plus - Quit (See Exit)

See
Card Puncher Data Processing
SQL Plus - Script

You must include: a semicolon at the end of each SQL command and a slash (/) on a new line at the end of each PL/SQL block with the @ or the start command where: The exit error...
Card Puncher Data Processing
SQL Plus - WHENEVER SQLERROR

It performs the specified action (exits SQLPlus by default) if a SQL command or PL/SQL block generates an error. where: EXIT n is a number variable is a substitution variable BindVariable...



Share this page:
Follow us:
Task Runner