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