The SQL*Plus Buffer

The SQL*Plus buffer is an area that stores commands that are specific to your particular SQL session. These commands include the most recently executed SQL statement and commands that you have used to customize your SQL session, such as formatting commands and variable assignments. This buffer is like a short-term memory. Here are some of the most common SQL buffer commands:

  • LIST line_number— Lists a line from the statement in the buffer and designates it as the current line.

  • CHANGE/old_value/new_value— Changes old_value to new_value on the current line in the buffer.

  • APPEND text— Appends text to the current line in the buffer.

  • DEL— Deletes the current line in the buffer.

  • SAVE newfile— Saves the SQL statement in the buffer ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.