Database Compatibility for Oracle Developers v15
EDB Postgres Advanced Server makes Postgres look, feel, and operate more like Oracle, so when you migrate, there is less code to rewrite, and you can be up and running quickly. The Oracle compatibility features allow you to run many applications written for Oracle in EDB Postgres Advanced Server with minimal to no changes.
EDB Postgres Advanced Server provides Oracle 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
Further reading
- Compatible SQL syntax, data types, and views in Database Compatibility for Oracle Developers: SQL.
- Compatibility offered by the procedures and functions that are part of the built-in packages in Database Compatibility for Oracle Developers: Built-in Packages.
- Compatible tools and utilities (EDB*Plus, EDB*Loader, DRITA, and EDB*Wrap) that are included with an EDB Postgres Advanced Server installation in Tools and utilities.
- For applications written using the Oracle Call Interface (OCI), EDB’s Open Client Library (OCL) provides interoperability with these applications. See EDB OCL Connector.