本篇为预告，非正式内容，
在openGauss2.1.0版本上开发兼容package,需要考虑A兼容模式支持package的冲突问题,因此可能需要写两个版本,一个用于老版本或非A兼容模式版本,一个用于2.1.0版本之后的A兼容模式。
参考此文【openGauss】谈一谈PostgreSQL及openGauss中的package
package列表
下列包名为我初次筛选，在开发中可能会用到的包
| 包名 | 主要功能 | compat-tools是否已含 | 本人是否可能会进行开发 | 本人开发进度 | 本人完成日期 |
|---|---|---|---|---|---|
| DBMS_HADOOP | 在数据库中集成对HIVE及HADOOP进行操作、查询的功能 | N | |||
| DBMS_JOB | 作业管理 | Y | N | ||
| DBMS_LOB | 大参数操作包 | ? | |||
| DBMS_MLE | 多开发语言引擎(目前Oracle只支持JS) | N | |||
| DBMS_METADATA | 元数据管理 | Y | N | ||
| DBMS_OUTPUT | 控制台输出信息 | Y | N | ||
| DBMS_RANDOM | 随机值 | Y | N | ||
| DBMS_REPORT | 数据库报告 | N | |||
| DBMS_SCHEDULER | 作业管理 | N | |||
| DBMS_SQL | SQL相关包 | ? | |||
| DBMS_SQLTUNE | SQL调优包 | N | |||
| DBMS_SQL_TRANSLATOR | SQL翻译(用于对不同sql语法数据库的sql转换或执行) | N | |||
| DBMS_TF | 多态表函数 | N | |||
| DBMS_UTILITY | 多种实用工具 | Y(部分) | Y | ||
| DIUTIL | DI工具 | Y | |||
| SQLJUTL | SQLJ工具(特定的一些类型转换,例如布尔到整形) | Y | |||
| UTL_COMPRESS | 压缩解压 | ? | |||
| UTL_ENCODE | 各种编码解码 | Y | |||
| UTL_FILE | 文件工具包 | ? | |||
| UTL_HTTP | HTTP工具包 | ? | |||
| UTL_I18N | I18N工具包 | Y | |||
| UTL_INADDR | 根据域名获取IP或根据IP获取域名 | ? | |||
| UTL_MATCH | 匹配两个字符串的相似度 | Y | |||
| UTL_LMS | 可以根据不同语言输出报错信息 | ? | |||
| UTL_NLA | 向量矩阵计算 | ? | |||
| UTL_RAW | 二进制数据工具包 | Y | |||
| UTL_SMTP | 邮件工具包 | ? | |||
| UTL_TCP | TCP工具包 | ? | |||
| UTL_URL | URL工具包 | Y | 完成 | 20220202 | |
| UTL_XML | XML工具包 | N | |||
| dbms_application_info | 应用信息工具包 | Y | N | ||
| DBMS_LOCK | 锁定(主要使用sleep过程来延时) | Y | N |
子程序明细
| 包名 | 过程或函数名 | 重载 | COMPAT-TOOLS是否已有 | 开发进度 | 完成日期 |
|---|---|---|---|---|---|
| DBMS_UTILITY | ACTIVE_INSTANCES | ||||
| DBMS_UTILITY | ANALYZE_DATABASE | ||||
| DBMS_UTILITY | ANALYZE_PART_OBJECT | ||||
| DBMS_UTILITY | ANALYZE_SCHEMA | ||||
| DBMS_UTILITY | CANONICALIZE | Y | |||
| DBMS_UTILITY | COMMA_TO_TABLE | 2 | Y | ||
| DBMS_UTILITY | COMMA_TO_TABLE | 1 | Y | ||
| DBMS_UTILITY | COMPILE_SCHEMA | ||||
| DBMS_UTILITY | CREATE_ALTER_TYPE_ERROR_TABLE | ||||
| DBMS_UTILITY | CURRENT_INSTANCE | ||||
| DBMS_UTILITY | DATA_BLOCK_ADDRESS_BLOCK | ||||
| DBMS_UTILITY | DATA_BLOCK_ADDRESS_FILE | ||||
| DBMS_UTILITY | DB_VERSION | 1 | Y | ||
| DBMS_UTILITY | DB_VERSION | 2 | Y | ||
| DBMS_UTILITY | DIRECTORY_HAS_SYMLINK | ||||
| DBMS_UTILITY | EXEC_DDL_STATEMENT | Y | |||
| DBMS_UTILITY | EXPAND_SQL_TEXT | ||||
| DBMS_UTILITY | FORMAT_CALL_STACK | ||||
| DBMS_UTILITY | FORMAT_ERROR_BACKTRACE | ||||
| DBMS_UTILITY | FORMAT_ERROR_STACK | ||||
| DBMS_UTILITY | GET_CPU_TIME | ||||
| DBMS_UTILITY | GET_DEPENDENCY | ||||
| DBMS_UTILITY | GET_ENDIANNESS | ||||
| DBMS_UTILITY | GET_HASH_VALUE | ||||
| DBMS_UTILITY | GET_PARAMETER_VALUE | ||||
| DBMS_UTILITY | GET_SQL_HASH | ||||
| DBMS_UTILITY | GET_TIME | ||||
| DBMS_UTILITY | GET_TZ_TRANSITIONS | ||||
| DBMS_UTILITY | INIT_NUMBER_ARRAY | ||||
| DBMS_UTILITY | INVALIDATE | ||||
| DBMS_UTILITY | IS_BIT_SET | ||||
| DBMS_UTILITY | IS_CLUSTER_DATABASE | ||||
| DBMS_UTILITY | MAKE_DATA_BLOCK_ADDRESS | ||||
| DBMS_UTILITY | NAME_RESOLVE | ||||
| DBMS_UTILITY | NAME_TOKENIZE | ||||
| DBMS_UTILITY | OLD_CURRENT_SCHEMA | ||||
| DBMS_UTILITY | OLD_CURRENT_USER | ||||
| DBMS_UTILITY | PORT_STRING | ||||
| DBMS_UTILITY | SQLID_TO_SQLHASH | ||||
| DBMS_UTILITY | TABLE_TO_COMMA | 1 | |||
| DBMS_UTILITY | TABLE_TO_COMMA | 2 | |||
| DBMS_UTILITY | VALIDATE | 1 | |||
| DBMS_UTILITY | VALIDATE | 2 | |||
| DBMS_UTILITY | WAIT_ON_PENDING_DML | ||||
| DIUTIL | ATTRIBUTE_USE_STATISTICS | ||||
| DIUTIL | BOOL_TO_INT | ||||
| DIUTIL | GET_D | ||||
| DIUTIL | GET_DIANA | ||||
| DIUTIL | INT_TO_BOOL | ||||
| DIUTIL | NODE_USE_STATISTICS | ||||
| DIUTIL | SUBPTXT | ||||
| SQLJUTL | BOOL2INT | ||||
| SQLJUTL | CHAR2IDS | ||||
| SQLJUTL | CHAR2IYM | ||||
| SQLJUTL | GET_TYPECODE | ||||
| SQLJUTL | HAS_DEFAULT | ||||
| SQLJUTL | IDS2CHAR | ||||
| SQLJUTL | INT2BOOL | ||||
| SQLJUTL | IYM2CHAR | ||||
| SQLJUTL | URI2VCHAR | ||||
| UTL_ENCODE | BASE64_DECODE | 完成 | 20220203 | ||
| UTL_ENCODE | BASE64_ENCODE | 完成 | 20220203 | ||
| UTL_ENCODE | MIMEHEADER_DECODE | ||||
| UTL_ENCODE | MIMEHEADER_ENCODE | ||||
| UTL_ENCODE | QUOTED_PRINTABLE_DECODE | ||||
| UTL_ENCODE | QUOTED_PRINTABLE_ENCODE | ||||
| UTL_ENCODE | TEXT_DECODE | ||||
| UTL_ENCODE | TEXT_ENCODE | ||||
| UTL_ENCODE | UUDECODE | ||||
| UTL_ENCODE | UUENCODE | ||||
| UTL_I18N | ENCODE_SQL_XML | ||||
| UTL_I18N | ESCAPE_REFERENCE | ||||
| UTL_I18N | GET_COMMON_TIME_ZONES | ||||
| UTL_I18N | GET_DEFAULT_CHARSET | ||||
| UTL_I18N | GET_DEFAULT_ISO_CURRENCY | ||||
| UTL_I18N | GET_DEFAULT_LINGUISTIC_SORT | ||||
| UTL_I18N | GET_LOCAL_LANGUAGES | ||||
| UTL_I18N | GET_LOCAL_LINGUISTIC_SORTS | ||||
| UTL_I18N | GET_LOCAL_TERRITORIES | ||||
| UTL_I18N | GET_LOCAL_TIME_ZONES | ||||
| UTL_I18N | GET_MAX_CHARACTER_SIZE | ||||
| UTL_I18N | GET_TRANSLATION | ||||
| UTL_I18N | MAP_CHARSET | ||||
| UTL_I18N | MAP_FROM_SHORT_LANGUAGE | ||||
| UTL_I18N | MAP_LANGUAGE_FROM_ISO | ||||
| UTL_I18N | MAP_LOCALE_TO_ISO | ||||
| UTL_I18N | MAP_TERRITORY_FROM_ISO | ||||
| UTL_I18N | MAP_TO_SHORT_LANGUAGE | ||||
| UTL_I18N | RAW_TO_CHAR | 1 | |||
| UTL_I18N | RAW_TO_CHAR | 2 | |||
| UTL_I18N | RAW_TO_NCHAR | 1 | |||
| UTL_I18N | RAW_TO_NCHAR | 2 | |||
| UTL_I18N | STRING_TO_RAW | ||||
| UTL_I18N | TRANSLITERATE | ||||
| UTL_I18N | UNESCAPE_REFERENCE | ||||
| UTL_I18N | VALIDATE_CHARACTER_ENCODING | 2 | |||
| UTL_I18N | VALIDATE_CHARACTER_ENCODING | 1 | |||
| UTL_I18N | VALIDATE_SQLNAME | ||||
| UTL_MATCH | EDIT_DISTANCE | ||||
| UTL_MATCH | EDIT_DISTANCE_SIMILARITY | ||||
| UTL_MATCH | JARO_WINKLER | ||||
| UTL_MATCH | JARO_WINKLER_SIMILARITY | ||||
| UTL_RAW | BIT_AND | ||||
| UTL_RAW | BIT_COMPLEMENT | ||||
| UTL_RAW | BIT_OR | ||||
| UTL_RAW | BIT_XOR | ||||
| UTL_RAW | CAST_FROM_BINARY_DOUBLE | ||||
| UTL_RAW | CAST_FROM_BINARY_FLOAT | ||||
| UTL_RAW | CAST_FROM_BINARY_INTEGER | ||||
| UTL_RAW | CAST_FROM_NUMBER | ||||
| UTL_RAW | CAST_TO_BINARY_DOUBLE | ||||
| UTL_RAW | CAST_TO_BINARY_FLOAT | ||||
| UTL_RAW | CAST_TO_BINARY_INTEGER | ||||
| UTL_RAW | CAST_TO_NUMBER | ||||
| UTL_RAW | CAST_TO_NVARCHAR2 | ||||
| UTL_RAW | CAST_TO_RAW | ||||
| UTL_RAW | CAST_TO_VARCHAR2 | ||||
| UTL_RAW | COMPARE | ||||
| UTL_RAW | CONCAT | ||||
| UTL_RAW | CONVERT | ||||
| UTL_RAW | COPIES | ||||
| UTL_RAW | LENGTH | ||||
| UTL_RAW | OVERLAY | ||||
| UTL_RAW | REVERSE | ||||
| UTL_RAW | SUBSTR | ||||
| UTL_RAW | TRANSLATE | ||||
| UTL_RAW | TRANSLITERATE | ||||
| UTL_RAW | XRANGE | ||||
| UTL_URL | ESCAPE | 完成 | 20220202 | ||
| UTL_URL | UNESCAPE | 完成 | 20220202 |
近期有其他事要忙，进度暂停
项目地址
https://gitee.com/darkathena/opengauss-oracle
20220201更新
年后慢慢开整
