What is Input Buffer in SQL*Plus?

<<Previous  Next>>

Oracle - What is Input Buffer in SQL*Plus? - June 27, 2009 at 11:00 AM

What is Input Buffer in SQL*Plus?  

Input buffer feature of the command-line SQL*Plus tool allows a revision of multiple-line command and rerunning it with a couple of simple commands. The last SQL statement is always stored in the buffer.

Commands:

LIST:  Displays the last executed SQL statement in the buffer

RUN OR ";"    Runs the SQL statement in the buffer again.

CLEAR BUFFER:    Removes the SQL statement in the buffer

INPUT line     Adds a new line into the buffer

APPEND text     Appends more text to the last line in the buffer

DEL         Deletes one line from the buffer

CHANGE /old/new      Replaces 'old' text with 'new' text in the buffer

By default, input buffer is always turned on in SQL*Plus.

Also read

What is SQL*Plus?

SQL*Plus is an interactive and batch query tool, it gets installed with every Oracle Database Server or Client installation.............

Explain how to change SQL*Plus system settings.

The SET command can be used to change the settings in the SQl*PLUS environment : SET AUTOCOMMIT OFF: Turns off the auto-commit feature, SET FEEDBACK OFF............

What are SQL*Plus Environment variables?

The behaviour of SQL PLUS depends on some environmental variables predefined in the OS: ORACLE_HOME: This variable stores the home directory where the Oracle client..............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience