SQL Plus - Command Reference

Card Puncher Data Processing

Help

sys@orcl>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

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.





Discover More
Card Puncher Data Processing
(SQL Plus|SqlCl) (Oracle Database Console)

SQLPlus is the first client of the Oracle Database. On windows, there is two versions of SQLPlus : a GUI one (sqlplusw.exe) Officialy deprecated in the next release of Oracle.Documentation...
Card Puncher Data Processing
SQL Plus - ACCEPT command (Console Interaction)

The accept command reads a line of input and stores it in a given substitution variable. where: variable is the variable command prompt is the prompt command HIDE will hide the input For...
Card Puncher Data Processing
SQL Plus - Column Command

The column command: specifies display attributes for a given column, such as: text for the column heading alignment for the column heading format for NUMBER data wrapping of column data lists...
Card Puncher Data Processing
SQL Plus - Connect

CONNECT is a SQLPlus command that permits to make a connection as a user with a database (instance of). where: logon has the following syntax: username/password@connect_identifier proxy has the...
Card Puncher Data Processing
SQL Plus - LIST (the SQL Buffer)

The list command lists one or more lines of the SQL buffer. where: n is the first line to show m is the last line to show LAST is an alias for the last line of the buffer Enter LIST or...
Card Puncher Data Processing
SQL Plus - Print (Bind Variables)

Print is a command that displays the current values of bind variables, or lists all bind variables. PROMPT
Card Puncher Data Processing
SQL Plus - Prompt

Prompt is an command that sends the specified message or a blank line to the user's screen. TERM system variable Using two semicolons caused a single semicolon to be displayed The PROMPT command...
Card Puncher Data Processing
SQL Plus - SQL Buffer

The SQL Buffer contains the most recently executed: SQL command or PL/SQL block The buffer has no command history list and does not record SQLPlus commands. at the beginning, just use 0...
Card Puncher Data Processing
SQL Plus - Show (System Variable) Command

The SHOW command shows the value of: a SQLPlus system variable or the current SQLPlus environment. SHOW SGA requires a DBA privileged login. where option represents one of the following: ...
Card Puncher Data Processing
SQL Plus - Variable

VARIABLE is a function that: declares a bind variable that can be referenced in SQL and PL/SQL lists the current display characteristics for a single variable or all variables. substitution variable...



Share this page:
Follow us:
Task Runner