Oracle support

If you are migrating from Oracle, or your application was built using Oracle-specific syntax, compatibility with Oracle is a prerequisite for your Postgres database.

Only EDB Postgres Advanced Server supports Oracle features and syntax, among others:

• dblink_ora functions and procedures

• Partitioning commands compatible with Oracle databases

• Built-in Oracle packages

• Oracle catalog views

• Oracle-compatible SQL commands

• Oracle-compatible configuration parameters

• Oracle MERGE

• Oracle data types

• Oracle keywords

• Oracle functions and operators

To know which plan to get based on your Postgres distribution requirements, see EDB Subscription Plans Comparison.