SQL * PLUS common command list

Software Environment: 1. Windows 98 Second Edition 2, Oracle Database Version: Personal Oracle7 Release 7.3.4.0.03, Oracle Installation Path is: C: / ORAWIN95

Command List: Suppose the current execution command is: select * from tab;

(a) Ppend Add Text to Buffer Current Row A ORDER BY TNAME Results: Select * from Tab ORDER BY TNAME; (Note: A Back with 2 Spaces) (C) Hange / Old / New In the current new Text replacing the old text c / * / tname results: select tname from tab; (c) Hange / text Delete text C / Tab from the current row: SELECT TNAME FROM; DEL Delete Del N Delete Nth Ring (i) NPUT text Add a line (L) IST display buffer after the current line (L) IST N display buffer in the N-line (1) IST MN display buffer in the N-line RUN executes the command of the current buffer / Execute the command R in the current buffer R to perform the command @ file name of the current buffer to run the SQL file that is transferred to the memory, such as:

SQL> Edit S If there is no S.sql file in the current directory, the system automatically generates the S.sql file where "SELECT * from Tab;", the storage exits.

SQL> @S The system will automatically query all the tables, views, synonyms under the current user.

The @@ file name is called to make a .sql file in the .sql file.

The Save file name uses the command of the buffer in a file mode store, the default file extension is called the SQL file START file name that is called into the storage disk. SQL file.

The spool file name puts this after the various operations and execution results "Spoolery" ready-on-board to disk files, the default file extension is .lstspool Display current "spool" status spool off output

Example: SQL> Spool Asql> Spool Positive Offline to a.lstsql> Spool Offsql> Spool Current No Spanning

EXIT Exit SQL * Plusdesc Table Name Display Table Structure Show User Display Current Connection User Show Error Show Error SHOW ALL Show All 68 System Variable Value Edit Open the Default Editor, the default is NotePad.exe in the Windows system, the buffer is last A SQL statement is transferred to the Afiedt.buf file to edit the Edit file name to edit the .sql file specified in the current directory.

Clear Screen Clear Current Screen Display