本文为您介绍PolarDB PostgreSQL版(兼容Oracle)常用功能的Oracle兼容性说明。PolarDB PostgreSQL版(兼容Oracle)高度兼容Oracle,常用功能详情如下:分类子类分区表PARTITION BY RANGEPARTITION BY HASHPARTITION BY LISTSUB-PARTITIONING数据类型NUMBERVARCHAR2 , NVARCHAR2CLOBBLOBRAWLONG RAWDATESQL语法HIERARCHICAL QUERIESSYNONYMS (PUBLIC AND PRIVATE)SEQUENCE GENERATORHINT函数DECODEROWNUMSYSDATESYSTIMESTAMPNVLNVL2安全Database Firewall Only (SQL/Protect)VPDPROFILES FOR PASSWORDSPL/SQLPL/SQL CompatibleNAMED PARAMETER NOTATION FOR STORED PROCEDURESTRIGGERSREF CURSORSIMPLICIT / EXPLICIT CURSORSANONYMOUS BLOCKSBULK COLLECT/BINDASSOCIATIVE ARRAYSNESTED TABLESVARRAYSPL/SQL SUPPLIED PACKAGESPRAGMA EXCEPTION_INITPRAGMA AUTONOMOUS_TRANSACTIONUSER DEFINED EXCEPTIONSOBJECT TYPESSUB-TYPES包包内置函数高级功能AWR使用说明客户端驱动PolarPlusJDBC.NETODBCOCIPHP
本文为您介绍PolarDB PostgreSQL版(兼容Oracle)常用功能的Oracle兼容性说明。PolarDB PostgreSQL版(兼容Oracle)高度兼容Oracle,常用功能详情如下:分类子类分区表PARTITION BY RANGEPARTITION BY HASHPARTITION BY LISTSUB-PARTITIONING数据类型NUMBERVARCHAR2 , NVARCHAR2CLOBBLOBRAWLONG RAWDATESQL语法HIERARCHICAL QUERIESSYNONYMS (PUBLIC AND PRIVATE)SEQUENCE GENERATORHINT函数DECODEROWNUMSYSDATESYSTIMESTAMPNVLNVL2安全Database Firewall Only (SQL/Protect)VPDPROFILES FOR PASSWORDSPL/SQLPL/SQL CompatibleNAMED PARAMETER NOTATION FOR STORED PROCEDURESTRIGGERSREF CURSORSIMPLICIT / EXPLICIT CURSORSANONYMOUS BLOCKSBULK COLLECT/BINDASSOCIATIVE ARRAYSNESTED TABLESVARRAYSPL/SQL SUPPLIED PACKAGESPRAGMA EXCEPTION_INITPRAGMA AUTONOMOUS_TRANSACTIONUSER DEFINED EXCEPTIONSOBJECT TYPESSUB-TYPES包包内置函数高级功能AWR使用说明客户端驱动PolarPlusJDBC.NETODBCOCIPHP