@ pathname Run an SQL Script (see START)
@MyScript.sql parameter1 parameter2 parameter3
In the SQL-Script, refer to the parameters as &1, &2, and &3.
@@ pathname Run a nested SQL Script.
/ Execute (or re-execute) commands in the SQL*Plus buffer
does not list commands before running
ACCEPT User input
ACC[EPT] [NUM[BER]|CHAR|DATE] [FORMAT ]
[DEFAULT default] [PROMPT text|NOPROMPT] [HIDE]
APPEND Add text to the end of the current line in the buffer.
A[PPEND] text_to_add
BREAK Specify where and how formatting will change.
BREAK ON {column|expr|ROW|REPORT} action
BTITLE Place and format a title at the bottom of each page.
BTITLE printspec [text|variable]
BTITLE [OFF|ON]
CHANGE Change text on the current line.
C /oldval/newval
CLEAR Clear the SQL*Plus screen and the screen buffer.
CLEAR {BREAKS|BUFFER|COLUMNS|COMPUTES|SCREEN|SQL TIMING}
Change display width of a column.
Calculate and display totals.
Connect to a database as a specified user.
connect username/password@SID
Copy data from a query into a table (local or remote)
DEFINE User :
DEFINE varName = String
Display a user variable
DEFINE varName
Display all variables
DEFINE
DEFINE_EDITOR = sql*plus editor (e.g. DEFINE_EDITOR=vim.exe)
DEL Delete the current line in the SQL buffer
DESC[RIBE] Describe a table, column, view, synonym, function
procedure, package or package contents.
DISCONNECT Logoff (but don't exit)
EDIT Load the SQL*Plus buffer into an editor.
By default, saves the file to AFIEDT.BUF
Run a single PLSQL statement
EXEC :answer := EMP_PAY.BONUS('SMITH')
EXIT [n] Commit, logoff and exit (n = error code)
EXIT SQL.SQLCODE
GET file Retrieve a previously stored command file
HELP topic Topic is an SQL PLUS command or HELP COMMANDS
HOST Execute a host operating system command
HOST CD scripts
INPUT Edit sql buffer - add line(s) to the buffer
LIST n m Edit sql buffer - display buffer lines n to m
For all lines - specify m as LAST
PAUSE message Wait for the user to hit RETURN
PRINT variable List the value of a bind variable or REF Cursor (see VARIABLE / SHOW)
PROMPT message Echo a message to the screen
REMARK comment or --comment-- or /* comment */
RUN Execute (or re-execute) commands in the SQL*Plus buffer
Lists the commands before running
RUNFORM Run a SQL*Forms application
SAVE file Save the contents of the SQL*Plus buffer in a command file
SAVE file [CRE[ATE] | REP[LACE] | APP[END]]
Display or change SQL*Plus settings
SHOW List the value of a system variable (see PRINT)
[ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL]
SPOOL file Store query results in file
SPOOL OFF Turn off spooling
SPOOL OUT sends file to printer
Start SQL*Plus and connect to a database.
STA[RT] Run an SQL Script (see @)
[NoMOUNT|MOUNT|OPEN]
TIMING Record timing data TIMING {START | SHOW | STOP}
see CLEAR TIMING
TTITLE Define a page title
UNDEFINE Delete a user variable or passed parameter (see DEFINE)
VARIABLE Define a bind variable
(Can be used in both SQLPlus and PLSQL)
VAR[IABLE] [variable {NUMBER|CHAR|CHAR (n)}]
VARIABLE on its own will display the definitions made.
WHENEVER OSERROR Exit if an OS error occurs
WHENEVER SQLERROR Exit if an SQL or PLSQL error occurs
"Client Servers were a tremendous mistake and we are sorry that we sold it to you. Instead of applications running on the desktop and data sitting on the server, everything will be Internet based"
- Larry Ellison, CEO, Oracle Corp.
阅读(585) | 评论(0) | 转发(0) |