The SQL noted in "Table 9.1 Features compatible with Oracle databases" can be used in the interface for application development. However, outer join operators cannot be used when integrated with Visual Studio.
When integrated with Visual Studio or using the features compatible with Oracle databases from Fujitsu Npgsql .NET Data Provider, select one of the actions below for the SearchPath parameter, which is one of the pieces of information needed to connect to databases specified for individual connections.
Do not specify the SearchPath parameter itself, or
Specify both "public" and the schema name in the SQL statement.
Note that both "public" and the schema name in the SQL statement must be specified as the SearchPath parameter before "oracle" and "pg_catalog" when using the Oracle database-compatible feature SUBSTR.
