本文為您介紹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