SQL Plus - SQL Buffer

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

The SQL Buffer contains the most recently executed:

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

Advertising

3 - How to

3.1 - 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

3.2 - List the buffer

3.3 - Change it

3.4 - Delete lines

3.5 - Save it

3.6 - Delete all lines

CLEAR BUFFER

3.7 - Run it

4 - 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
Advertising