-
del [ *|n [m|last] ]
-
Deletes the current line, or one or more lines of the buffer.
DEL makes the following line of the buffer the current line.
-
i [ new line ]
-
Inserts a new line or several lines of text after current line in buffer.
SQL> i where SSN = '123456789'
-
edit [ filename ]
-
EDIT invokes a line editor on the contents of the specified file or on the contents of the buffer.
SQL> edit
2 q
-
‘;’, run, or ‘/’
-
Lists and executes the SQL command or PL/SQL block currently in the SQL buffer. ‘;’ and ‘/’ do not list the command.
SQL> SELECT * FROM customers
2 WHERE name = 'Pokemon';
-
@filename
-
Executes SQL statements stored in a host operating system file named.
-
get filename
-
GET loads a host operating system file into the SQL buffer.
-
save filename
-
SAVE stores the SQL buffer’s contents in a host operating system file.
-
host command
-
HOST executes a host system command without leaving the SQL*Plus.
SQL> host date
Mon Aug 24 09:54:03 CST 2020
SQL> host sh exer1