10.2.3 Notes when Integrating with the Interface for Application Development

Enterprise Postgres 17 SP1 Application Development Guide

Chapter 10 Compatibility with Oracle Databases > 10.2 Precautions when Using the Features Compatible with Oracle Databases > 10.2.3 Notes when Integrating with the Interface for Application Development

10.2.3 Notes when Integrating with the Interface for Application Development

The SQL noted in "Table 10.1 Features compatible with Oracle databases" can be used in the interface for application development.

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.