Table of Contents

About

The SQL Buffer contains the most recently executed:

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

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

List the buffer

SQL Plus - LIST (the SQL Buffer)

Change it

SQL Plus - CHANGE

Delete lines

SQL Plus - DEL

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