Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET FLAGGER

Synopsis

The FLAGGER setting checks your SQL statements for conformance to ANSI/ISO SQL92 syntax. You can choose from three compliance levels: entry, intermediate, and full.

Syntax

SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}

Parameters

OFF

Turns off this feature. This is the default setting.

ENTRY

Allows SQL statements that use only the entry-level features of the standard.

INTERMED[IATE]

Allows SQL statements that use the intermediate-level features of the standard.

FULL

Allows any SQL statement that is defined in the standard.

Using the SET FLAGGER command has the same effect as executing the statement ALTER DATABASE SET FLAGGER. However, SET FLAGGER is a SQL*Plus command, so you can execute it even before connecting to the database. Once you have turned this feature on, any attempt to execute a nonconforming statement will result in an error message such as the following:

ERROR:
ORA-00097: Use of Oracle SQL feature not in SQL92 Entry Level

This feature is useful if you are writing software for the federal government and are required to deliver an implementation that uses no nonstandard, vendor-specific features.