SQL Plus - Command Reference

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

Table of Contents

1 - Help

[email protected]>help index
Enter Help [topic] for help.

 @             COPY         PAUSE                    SHUTDOWN
 @@            DEFINE       PRINT                    SPOOL
 /             DEL          PROMPT                   SQLPLUS
 ACCEPT        DESCRIBE     QUIT                     START
 APPEND        DISCONNECT   RECOVER                  STARTUP
 ARCHIVE LOG   EDIT         REMARK                   STORE
 ATTRIBUTE     EXECUTE      REPFOOTER                TIMING
 BREAK         EXIT         REPHEADER                TTITLE
 BTITLE        GET          RESERVED WORDS (SQL)     UNDEFINE
 CHANGE        HELP         RESERVED WORDS (PL/SQL)  VARIABLE
 CLEAR         HOST         RUN                      WHENEVER OSERROR
 COLUMN        INPUT        SAVE                     WHENEVER SQLERROR
 COMPUTE       LIST         SET                      XQUERY
 CONNECT       PASSWORD     SHOW

2 - List

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 database.
DEFINE
DEL
DESCRIBE
DISCONNECT
LOG
EXECUTE
EXIT
GET
HELP
HOST
INPUT
LIST
PASSWORD
PAUSE
PRINT
PROMPT
QUIT
RECOVER
EDIT
REPFOOTER Places and formats a footer at the bottom of a report, or lists the REPFOOTER definition.
REPHEADER Places and formats a header at the top of a report, or lists the REPHEADER definition.
RESERVED WORDS (SQL)
RESERVED WORDS (PL/SQL)
RUN
SAVE Saves the contents of the SQL buffer in a script
SET
SHOW
SHUTDOWN Shuts down a currently running Oracle Database instance
SPOOL
SQLPLUS Starts SQL*Plus from the operating system prompt.
START Runs the SQL*Plus statements in the specified script
STARTUP Starts an Oracle instance
REMARK
STORE
TIMING
TTITLE
UNDEFINE
VARIABLE Declares a bind variable that can be referenced in PL/SQL
WHENEVER OSERROR Performs the specified action if an operating system error occurs
WHENEVER SQLERROR Performs the specified action if a SQL command or PL/SQL block generates an error.
XQUERY Performs an XQuery 1.0 query on a specified database.
Advertising