SQL Plus - SQL Buffer

About

The SQL Buffer contains the most recently executed:

SQL command
or PL/SQL block

The buffer has no command history list and does not record SQL*Plus commands.

Articles Related

How to

Append

at the beginning, just use 0 followed by your statement

0 1
0 2
0 3
list

1  3
  2  2
  3* 1

to a line number: 1-9

Example

1 hello
2 nico
list

1  hello
  2* nico

to the last line of the buffer: SQL Plus - APPEND (to the SQL Buffer)

List the buffer

SQL Plus - LIST (the SQL Buffer)

Change it

SQL Plus - CHANGE

Delete lines

Save it

SQL Plus - Save (The SQL Buffer)

Delete all lines

CLEAR BUFFER

Run it

SQL Plus - Run (the SQL Buffer)

Configuration

The name and location of the buffer file when editing it can be configured with the following variable

SET EDITFILE c:\temp\sqlbuffer.sql