3 ms·
So you mean that the feature Oracle has that Postges is missing is Oracle compatibility (unless you install it from a 3rd party)? That page doesn't list featur
by marcosdumay 4y ago
So you mean that the feature Oracle has that Postges is missing is Oracle compatibility (unless you install it from a 3rd party)?
That page doesn't list features. It only shows you tools to help migrating.
- chasil 4y agoThere 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.)