Oracle SQL - Using the SQL Buffer

  1. HOME
  2. Oracle SQL
  3. SQL Plus
  4. Introduction to SQL*Plus

Introduction

SQL*Plus stores the most recent SQL command in the SQL buffer.

You can display the contents of the SQL buffer using a SQL*Plus command called LIST. 

SQL> L
  1  select *
  2* from emp

SQL>

SQL*Plus commands can be abbreviated (L stands for LIST), whereas SQL commands cannot.

Related Topic