Document Center
 
All Products
Search
  • Document Center
  • PolarDB for Oracle
  • Developer Guide
  • Oracle compatibility

This Product

  • This Product
  • All Products

    Oracle compatibility

    Document Center

    Oracle compatibility

    Last Updated: Jan 04, 2022

    This topic describes the features supported by PolarDB for Oracle that is compatible with Oracle syntax.

    PolarDB for Oracle is highly compatible with Oracle. The common features are listed in the following table.

    Type Sub-type
    Partitioned table PARTITION BY RANGE
    PARTITION BY HASH
    PARTITION BY LIST
    SUB-PARTITIONING
    Data type NUMBER
    VARCHAR2 , NVARCHAR2
    CLOB
    BLOB
    RAW
    LONG RAW
    DATE
    SQL syntax HIERARCHICAL QUERIES
    SYNONYMS (PUBLIC AND PRIVATE)
    SEQUENCE GENERATOR
    HINT
    Function DUAL
    UTL_ENCODE
    ROWNUM
    SYSDATE
    SYSTIMESTAMP
    NVL
    NVL2
    Security Database Firewall Only (SQL/Protect)
    VPD
    PROFILES FOR PASSWORDS
    PL/SQL PL/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
    Packages Built-in functions
    Client driver PolarPlus
    JDBC
    .NET
    ODBC
    OCI
    PHP
    Previous: View or cancel a scheduled task Next: Connect to a PolarDB for Oracle cluster

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.