SQL*Plus User's Guide and Reference
Release 8.1.5

A66736-01

Library

Product

Contents

Index

Prev Up Next

Command Reference, 2 of 52


SQL*Plus Command Summary

Command  Description 
@
 

Runs the specified command file. 

@@
 

Runs a command file. 

/
 

Executes the SQL command or PL/SQL block. 

ACCEPT
 

Reads a line of input and stores it in a given user variable. 

APPEND
 

Adds specified text to the end of the current line in the buffer. 

ARCHIVE LOG
 

Starts or stops the automatic archiving of online redo log files, manually (explicitly) archives specified redo log files, or displays information about redo log files. 

ATTRIBUTE
 

Specifies display characteristics for a given attribute of an Object Type column, and lists the current display characteristics for a single attribute or all attributes. 

BREAK
 

Specifies where and how formatting will change in a report, or lists the current break definition. 

BTITLE
 

Places and formats a specified title at the bottom of each report page, or lists the current BTITLE definition. 

CHANGE
 

Changes text on the current line in the buffer. 

CLEAR
 

Resets or erases the current clause or setting for the specified option, such as BREAKS or COLUMNS. 

COLUMN
 

Specifies display characteristics for a given column, or lists the current display characteristics for a single column or for all columns. 

COMPUTE
 

Calculates and prints summary lines, using various standard computations, on subsets of selected rows, or lists all COMPUTE definitions. 

CONNECT
 

Connects a given username to Oracle. 

COPY
 

Copies data from a query to a table in a local or remote database. 

DEFINE
 

Specifies a user variable and assigns it a CHAR value, or lists the value and variable type of a single variable or all variables. 

DEL
 

Deletes one or more lines of the buffer. 

DESCRIBE
 

Lists the column definitions for the specified table, view, or synonym or the specifications for the specified function or procedure. 

DISCONNECT
 

Commits pending changes to the database and logs the current username off Oracle, but does not exit SQL*Plus. 

EDIT
 

Invokes a host operating system text editor on the contents of the specified file or on the contents of the buffer. 

EXECUTE
 

Executes a single PL/SQL statement. 

EXIT
 

Terminates SQL*Plus and returns control to the operating system. 

GET
 

Loads a host operating system file into the SQL buffer. 

HELP
 

Accesses the SQL*Plus help system. 

HOST
 

Executes a host operating system command without leaving SQL*Plus. 

INPUT
 

Adds one or more new lines after the current line in the buffer. 

LIST
 

Lists one or more lines of the SQL buffer. 

PASSWORD
 

Allows a password to be changed without echoing the password on an input device. 

PAUSE
 

Displays an empty line followed by a line containing text, then waits for the user to press [Return], or displays two empty lines and waits for the user's response. 

PRINT
 

Displays the current value of a bind variable. 

PROMPT
 

Sends the specified message or a blank line to the user's screen. 

RECOVER
 

Performs media recovery on one or more tablespaces, one or more datafiles, or the entire database. 

REMARK
 

Begins a comment in a command file. 

REPFOOTER
 

Places and formats a specified report footer at the bottom of each report, or lists the current REPFOOTER definition. 

REPHEADER
 

Places and formats a specified report header at the top of each report, or lists the current REPHEADER definition. 

RUN
 

Lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. 

SAVE
 

Saves the contents of the SQL buffer in a host operating system file (a command file). 

SET
 

Sets a system variable to alter the SQL*Plus environment for your current session. 

SHOW
 

Shows the value of a SQL*Plus system variable or the current SQL*Plus environment. 

SHUTDOWN
 

Shuts down a currently running Oracle instance, optionally closing and dismounting the database. 

SPOOL
 

Stores query results in an operating system file and, optionally, sends the file to a printer. 

START
 

Executes the contents of the specified command file. 

STARTUP
 

Starts an Oracle instance with several options, including mounting and opening a database. 

STORE
 

Saves attributes of the current SQL*Plus environment in a host operating system file (a command file). 

TIMING
 

Records timing data for an elapsed period of time, lists the current timer's title and timing data, or lists the number of active timers. 

TTITLE
 

Places and formats a specified title at the top of each report page, or lists the current TTITLE definition. 

UNDEFINE
 

Deletes one or more user variables that you defined either explicitly (with the DEFINE command) or implicitly (with an argument to the START command). 

VARIABLE
 

Declares a bind variable that can be referenced in PL/SQL. 

WHENEVER OSERROR
 

Exits SQL*Plus if an operating system command generates an error. 

WHENEVER SQLERROR
 

Exits SQL*Plus if a SQL command or PL/SQL block generates an error. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index