Database Compatibility for Oracle Developers v14

Database compatibility for Oracle means that an application runs in an Oracle environment as well as in the EDB Postgres Advanced Server (EDB Postgres Advanced Server) environment with minimal or no changes to the application code. Developing an application that is compatible with Oracle databases in the EDB Postgres Advanced Server requires special attention to which features are used in the construction of the application. For example, developing a compatible application means choosing compatible:

  • System and built-in functions for use in SQL statements and procedural logic.
  • Stored Procedure Language (SPL) when creating database server-side application logic for stored procedures, functions, triggers, and packages.
  • Data types that are compatible with Oracle databases
  • SQL statements that are compatible with Oracle SQL
  • System catalog views that are compatible with Oracle’s data dictionary

For detailed information about the compatible SQL syntax, data types, and views, see the Database Compatibility for Oracle Developers SQL Guide.

The compatibility offered by the procedures and functions that are part of the Built-in packages is documented in the Database Compatibility for Oracle Developers Built-in Package Guide.

For information about using the compatible tools and utilities (EDB*Plus, EDB*Loader, DRITA, and EDB*Wrap) that are included with an EDB Postgres Advanced Server installation, see the Database Compatibility for Oracle Developers Tools and Utilities Guide.

For applications written using the Oracle Call Interface (OCI), EDB’s Open Client Library (OCL) provides interoperability with these applications. For detailed information about using the Open Client Library, see the EDB Postgres Advanced Server OCL Connector Guide.

EDB Postgres Advanced Server contains a rich set of features that enables development of database applications for either PostgreSQL or Oracle. For more information about all of the features of EDB Postgres Advanced Server, see the user documentation available at the EDB website.

EDB Postgres Advanced Server documentation is available at:

https://www.enterprisedb.com/docs

configuration_parameters_compatible_with_oracle_databases about_the_examples_used_in_this_guide