Oracle compatibility reference v16

This reference information applies to organizations migrating their Oracle applications to use EDB Postgres Advanced Server.

dblink_ora functions and procedures

Describes the functions and procedures supported by dblink_ora

Partitioning commands compatible with Oracle Databases

Listing of table partitioning syntaxes that are compatible with Oracle databases

Built-in packages

Listing of the built-in package support provided by EDB Postgres Advanced Server

Catalog Views

Listing of the catalog views support provided by EDB Postgres Advanced Server

Oracle-compatible SQL commands

Listing of SQL commands compatible with Oracle databases

List of Oracle compatible configuration parameters

Descriptions of the configuration parameters used to control system behaviors to act more like PostgreSQL or more like Oracle