Oracle SQL - Clearing Buffer and Screen

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

Introduction

With the CLEAR BUFFER command, you can empty the SQL buffer in SQL*Plus.

The SQL buffer is overwritten each time by consecutive commands.

With the CLEAR SCREEN command, you can start at the top of a new, empty SQL*Plus screen. 

SQL>CLEAR BUFFER 
   /

SQL>CLEAR SCREEN
   /

Related Topic