Oracle兼容性说明

本文为您介绍PolarDB-O常用功能的Oracle兼容性说明。

PolarDB-O高度兼容Oracle，常用功能详情如下：

分类	子类
分区表	PARTITION BY RANGE
	PARTITION BY HASH
	PARTITION BY LIST
	SUB-PARTITIONING
数据类型	NUMBER
	VARCHAR2 , NVARCHAR2
	CLOB
	BLOB
	RAW
	LONG RAW
	DATE
SQL语法	HIERARCHICAL QUERIES
	SYNONYMS (PUBLIC AND PRIVATE)
	SEQUENCE GENERATOR
	HINT
函数	DUAL
	DECODE
	ROWNUM
	SYSDATE
	SYSTIMESTAMP
	NVL
	NVL2
安全	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
包	包内置函数
客户端驱动	polarplus
	JDBC
	.NET
	ODBC
	OCI
	PHP