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

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

TypeSub-type
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
FunctionUTL_ENCODE
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
Client driverPolarPlus
JDBC
.NET
ODBC
OCI
PHP