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

Del

Save it

SQL Plus - Save (The SQL Buffer)

Delete all lines

CLEAR BUFFER

Run it

Run

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