3 ms·
There used to be PDF details there. Here is a synopsis, there is probably more. EDB Postgres Advanced Server is an enhanced version of PostgreSQL that offers
by chasil 4y ago
There used to be PDF details there.
Here is a synopsis, there is probably more.
EDB Postgres Advanced Server is an enhanced version of PostgreSQL that offers compatibility with Oracle in the following areas:
Oracle-specific and syntax-compatible database object types
Oracle-specific data types
Oracle-specific SQL extensions
Oracle PL/SQL support as a built-in native procedural language
Oracle data dictionary views (i.e., ALL_, DBA_, USER_ views)
Oracle built in PL/SQL packages
EDB Postgres Advanced Server doesn't fully implement all Oracle-specific features in these areas. Nevertheless, the compatibility is extensive and covers many of the most commonly used Oracle constructs.
https://www.enterprisedb.com/docs/migrating/oracle/migration_techniques/ https://www.enterprisedb.com/docs/migrating/oracle/migration...
(If you don't care for Oracle, don't use their database. However, SQL/PSM is the ISO PSM-96 standard; using this dialect will be maximally portable.)