PolarDB for PostgreSQL (Compatible with Oracle) provides comprehensive compatibility with Oracle syntax. It uses a shared-everything architecture and maintains a file organization and multiversion concurrency control model consistent with Oracle. The service supports common Oracle syntax, features, and the native OCI. This comprehensive support enables a one-click migration from Oracle to the cloud.
PolarDB for PostgreSQL (Compatible with Oracle) is highly compatible with Oracle syntax. It fully supports all basic Oracle data types and built-in objects, such as built-in functions, core packages, and key system views. The service supports advanced features, including subpartition management, global indexes, nested autonomous transactions, CONNECT BY hierarchical queries, the ROWNUM pseudocolumn, synonyms, native JSON types, flashback table, and global temporary tables. It also fully supports the Oracle procedural language framework, including standard PL/SQL programming paradigms, custom package development specifications, high-dimensional collection types, and key programming elements such as the composition, nesting, and method invocation of these collection types. Based on thousands of real-world customer migrations, assessments by the Advanced Database & Application Migration (ADAM) tool show a syntax compatibility rate of over 95% with Oracle.
PolarDB for PostgreSQL (Compatible with Oracle) supports a rich set of table partitioning features, including range partitioning, interval partitioning, partition splitting and merging, and partition templates. Global indexes on partitioned tables can significantly improve query performance.
Stored procedure language
Stored procedures are a common way to develop business applications, making the language familiar to many developers. PolarDB for PostgreSQL (Compatible with Oracle) is highly compatible with the Oracle stored procedure language and supports numerous syntaxes, including COLLECTION, GOTO, SAVEPOINT, ROLLBACK TO, CURSOR, and EXECUTE IMMEDIATE RETURN.
Database links
Database links allow you to integrate data from different data sources into PolarDB for PostgreSQL (Compatible with Oracle) and query it as if it were local data. Three methods are available: foreign data wrapper, database link, and dblink function. These methods enable data connections between various popular database products, such as PolarDB for PostgreSQL (Compatible with Oracle) to PolarDB for PostgreSQL (Compatible with Oracle), PolarDB for PostgreSQL (Compatible with Oracle) to Oracle, PolarDB for PostgreSQL (Compatible with Oracle) to PostgreSQL, and PolarDB for PostgreSQL (Compatible with Oracle) to MySQL. When you run complex SQL queries using database links, PolarDB for PostgreSQL (Compatible with Oracle) applies optimizations like predicate pushdown, join pushdown, sort pushdown, and aggregation pushdown. These optimizations push computations to the remote database whenever possible, significantly improving query performance.
Advanced feature compatibility
In addition to Oracle compatibility, PolarDB for PostgreSQL (Compatible with Oracle) also supports advanced features like hints, SQL plan management (SPM), CREATE TYPE, materialized views, and profiles, along with common drivers such as OCI and Pro*C. PolarDB for PostgreSQL (Compatible with Oracle) is 100% compatible with PostgreSQL. This compatibility extends to PostgreSQL syntax and its tool ecosystem, giving users a more diverse database environment.