SQL Plus

Oracle SQL * Plus Commands - Reference Manual
The following commands can be issued in SQL*Plus (in addition to the standard SQL commands.) -
 @ 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] variable [NUM[BER] - CHAR - DATE] [FORMAT 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}
COLUMN Change display width of a column.
COMPUTE Calculate and display totals.
CONNECT Connect to a database as a specified user. connect username/password@SID
COPY Copy data from a query into a table (local or remote) DEFINE User variables : 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
EXECUTE 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 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]]
SET Display or change SQL*Plus settings SHOW List the value of a system variable (see PRINT)
SHUTDOWN [ABORT - IMMEDIATE - NORMAL - TRANSACTIONAL] SPOOL file Store query results in file SPOOL OFF Turn off spooling SPOOL OUT sends file to printer
SQLPLUS Start SQL*Plus and connect to a database. STA[RT] Run an SQL Script (see @)
STARTUP [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
Oracle - Latest Oracle Information. Oracle in Server, Desktops, Tablets, Mobile Phones. Oracle News.
What is Oracle ?
SQL Plus Software development
Oracle Directory Resources - Sites, Books and Magazines
Oracle Corporation Company Information
Oracle Database DB and System Versions - Oracle How-to : How to install and configure.
Technology Oracle 2022


Zoom And Oracle Red Bull Racing Partnering Up On Technology And Marketing Forbes
Oracle Red Bull Racing gets into gear with Zoom to power team unified communications ComputerWeekly.com
Oracle Red Bull Racing ink partnership with Zoom Video Communications SportsMint Media
Zoom Video Communications : to Power Team Communication and Fan Experiences for Oracle Red Bull Racing Marketscreener.com
Zoom Provides UC for Oracle Red Bull Racing UC Today


11 health systems adopting Oracle Cerner's EHR tech to improve patient safety, satisfaction Becker's Hospital Review
Oracle Cerner Celebrates HIMSS Stage 7 and Davies Client Achievements cerner.com
University of Technology Sydney Gets Better Support and Security for Oracle Database by Switching to Rimini Street Yahoo Finance