SQL Plus - Flush System Variable

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

Table of Contents

1 - About

Flush is a system variable that controls when the output is sent to the user's display device.

OFF is recommended when:

  • you run a script that does not require user interaction
  • and whose output you do not need to see until the script finishes running.

OFF allows the host operating system to buffer output which may improve performance by reducing the amount of program input and output.

SET FLUSH is not supported in iSQL*Plus.