SQL Plus - SQL Buffer

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

Change it

Delete lines

Save it

Delete all lines

CLEAR BUFFER

Run it

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

Powered by ComboStrap