Case sensitivity for delimited identifiers is specified when the database is created. For details about createdb, see the Command Reference Guide and the System Administrator Guide.

Query flattening and default cursor mode options are specified when the DBMS Server is configured and started.

To determine the setting in effect, use the DBMSINFO function (see DBMSINFO Function--Return Information About the Current Session).