Document Center
 
All Products
Search
  • Document Center
  • PolarDB
  • PolarDB for PostgreSQL(Compatible with Oracle)
  • Developer Guide
  • Developer Guide (PolarDB for Oracle 1.0)
  • Oracle compatibility

This Product

  • This Product
  • All Products

    PolarDB:Oracle compatibility

    Document Center

    PolarDB:Oracle compatibility

    Last Updated:Sep 24, 2026

    This topic describes the Oracle compatibility of common features of PolarDB for PostgreSQL (Compatible with Oracle).

    PolarDB for PostgreSQL (Compatible with Oracle) is highly compatible with Oracle. The following table describes common features in detail:

    CategorySubcategory
    Partitioned tablePARTITION BY RANGE
    PARTITION BY HASH
    PARTITION BY LIST
    SUB-PARTITIONING
    Data typeNUMBER
    VARCHAR2, NVARCHAR2
    CLOB
    BLOB
    RAW
    LONG RAW
    DATE
    SQL syntaxHIERARCHICAL QUERIES
    SYNONYMS (PUBLIC AND PRIVATE)
    SEQUENCE GENERATOR
    HINT
    FunctionDECODE
    ROWNUM
    SYSDATE
    SYSTIMESTAMP
    NVL
    NVL2
    SecurityDatabase Firewall Only (SQL/Protect)
    VPD
    PROFILES FOR PASSWORDS
    PL/SQLPL/SQL Compatible
    NAMED PARAMETER NOTATION FOR STORED PROCEDURES
    TRIGGERS
    REF CURSORS
    IMPLICIT / EXPLICIT CURSORS
    ANONYMOUS BLOCKS
    BULK COLLECT/BIND
    ASSOCIATIVE ARRAYS
    NESTED TABLES
    VARRAYS
    PL/SQL SUPPLIED PACKAGES
    PRAGMA EXCEPTION_INIT
    PRAGMA AUTONOMOUS_TRANSACTION
    USER DEFINED EXCEPTIONS
    OBJECT TYPES
    SUB-TYPES
    PackagesBuilt-in functions
    Advanced featuresAWR usage instructions
    Client driverPolarPlus
    JDBC
    .NET
    ODBC
    OCI
    PHP
    Thank you! We've received your feedback.