Name

SET FLUSH — Not available in iSQL*Plus

Synopsis

The FLUSH setting indicates whether the host operating system is allowed to buffer output.

Syntax

SET FLU[SH] {OFF | ON}

Paremeters

SET FLU[SH]

Is the command, which may be abbreviated SET FLU.

OFF

Allows output to be buffered.

ON

Causes output to be displayed immediately. This is the default.

If you are running a command file, turning off FLUSH might keep you from seeing any output until SQL*Plus is finished executing that file.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.