Oracle Compatibility

Postgres Plus Advanced Server offers an enterprise-class alternative to Oracle at a fraction of the cost. With built-in native Oracle compatibility, customers are empowered to pursue initiatives that are simply not feasible in a high-priced database environment. Savings are achieved without impact to database functionality, reliability, security, or performance. Additionally, many advanced features, including data encryption, are standard with Postgres Plus Advanced Server, but are only available in other databases through expensive add-on modules.

Making the switch from Oracle requires virtually no modification to existing applications. The process is often completed in minutes and our customers report that more than 75% of their applications are 100% compatible, requiring no changes to run on Postgres Plus Advanced Server.

Applications developed on EnterpriseDB Advanced Server can leverage:

• PL/SQL syntax support including:
  • Packages
  • Stored procedures
  • Functions
  • Triggers
• Oracle data-types
• Built-in functions and packages
• Database links
• Synonyms
• Hierarchical queries
• Anonymous blocks
• Oracle data dictionary views
• Bulk bind and Bulk collect
• EDB*Plus
• EDB*Loader

And, with support for the most popular programming languages and connectors, including interoperability with OCI™, developing Oracle-compatible applications has never been easier.

Download the Oracle Compatibility Developer's Guide, a 300+ page compendium of Postgres Plus Advanced Server's deep Oracle compatibility.

Next (Performance)