Begin in the SQL*Plus window by choosing the Options menu.
Click Environment on the pop-up menu.
You now see the Environment window. The list on the left is all the environment settings available to you while you work in SQL*Plus. Click the down arrow on the scroll bar and scroll down until you see "FLAGGER" in the window.
Select "FLAGGER" to enable the setting boxes for this environment option.
The default setting of FLAGGER is OFF. Click the radio button labeled Custom in the Value box.
Now, type FULL in the text box inside the Value box and click the OK button.
You have returned to the main SQL*Plus window. Let's assume that you have just typed the query you see in the window. Press Enter to execute the query.
You see the resulting error messages caused by the FLAGGER. Even though the query is valid in Oracle, it includes the DECODE function which is an Oracle extension to SQL.
SET FLAGGER {OFF | ENTRY | INTERMEDIATE | FULL}
Checks to make sure that SQL statements conform to the ANSI/ISO SQL92 standard.
SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}
Checks to make sure that SQL statements conform to the ANSI/ISO SQL92 standard. If any non-standard constructs are found, the Oracle Database Server flags them as errors and displays the violating syntax. This is the equivalent of the SQL language ALTER SESSION SET FLAGGER command.
You may execute SET FLAGGER even if you are not connected to a database. FIPS flagging will remain in effect across SQL*Plus sessions until a SET FLAGGER OFF (or ALTER SESSION SET FLAGGER = OFF) command is successful or you exit SQL*Plus.
When FIPS flagging is enabled, SQL*Plus displays a warning for the CONNECT, DISCONNECT, and ALTER SESSION SET FLAGGER commands, even if they are successful.
SP2-0575 Use of Oracle SQL feature not in SQL92 Entry |Intermediate|Full Level
Cause: A SQL statement was attempted that is not FIPS compliant. May also occur if a SQL*Plus feature, for example SET AUTOTRACE, that uses Oracle-specific SQL was turned on when you are using FIPS flagging. Action: Use SET FLAGGER, and turn FIPS compliance checking OFF, or rewrite the statement.
SP2-0577 Usage:
SET FLAGGER {OFF | ENTRY | INTERMEDIATE | FULL}
Cause: An invalid option was specified in the SET FLAGGER command.
Action: Specify a valid option.
Table 2-5 describes the ALTER SESSION command rule settings.
Table 2-5: ALTER SESSION Command Rule Settings