Name

SET SUFFIX — Not available in iSQL*Plus

Synopsis

The SUFFIX setting controls the default extension used for command files.

Syntax

SET SUF[FIX] extension

Paremeters

SET SUF[FIX]

Is the command, which may be abbreviated SET SUF.

extension

Is the default extension to use when referring to SQL files. The default value for this setting is sql.

This setting is used by commands such as START, @, SAVE, and others that refer to SQL files. It doesn't apply to files created with the SPOOL command.

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.