侧边栏壁纸
  • 累计撰写 125 篇文章
  • 累计创建 13 个标签
  • 累计收到 0 条评论

目 录CONTENT

文章目录

【openGauss】openGauss补完计划二之ORACLE兼容PACKAGE

DarkAthena
2022-01-03 / 0 评论 / 0 点赞 / 978 阅读 / 15399 字

本篇为预告,非正式内容,
在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作业管理YN
DBMS_LOB大参数操作包?
DBMS_MLE多开发语言引擎(目前Oracle只支持JS)N
DBMS_METADATA元数据管理YN
DBMS_OUTPUT控制台输出信息YN
DBMS_RANDOM随机值YN
DBMS_REPORT数据库报告N
DBMS_SCHEDULER作业管理N
DBMS_SQLSQL相关包?
DBMS_SQLTUNESQL调优包N
DBMS_SQL_TRANSLATORSQL翻译(用于对不同sql语法数据库的sql转换或执行)N
DBMS_TF多态表函数N
DBMS_UTILITY多种实用工具Y(部分)Y
DIUTILDI工具Y
SQLJUTLSQLJ工具(特定的一些类型转换,例如布尔到整形)Y
UTL_COMPRESS压缩解压?
UTL_ENCODE各种编码解码Y
UTL_FILE文件工具包?
UTL_HTTPHTTP工具包?
UTL_I18NI18N工具包Y
UTL_INADDR根据域名获取IP或根据IP获取域名?
UTL_MATCH匹配两个字符串的相似度Y
UTL_LMS可以根据不同语言输出报错信息?
UTL_NLA向量矩阵计算?
UTL_RAW二进制数据工具包Y
UTL_SMTP邮件工具包?
UTL_TCPTCP工具包?
UTL_URLURL工具包Y完成20220202
UTL_XMLXML工具包N
dbms_application_info应用信息工具包YN
DBMS_LOCK锁定(主要使用sleep过程来延时)YN

子程序明细

包名过程或函数名重载COMPAT-TOOLS是否已有开发进度完成日期
DBMS_UTILITYACTIVE_INSTANCES
DBMS_UTILITYANALYZE_DATABASE
DBMS_UTILITYANALYZE_PART_OBJECT
DBMS_UTILITYANALYZE_SCHEMA
DBMS_UTILITYCANONICALIZEY
DBMS_UTILITYCOMMA_TO_TABLE2Y
DBMS_UTILITYCOMMA_TO_TABLE1Y
DBMS_UTILITYCOMPILE_SCHEMA
DBMS_UTILITYCREATE_ALTER_TYPE_ERROR_TABLE
DBMS_UTILITYCURRENT_INSTANCE
DBMS_UTILITYDATA_BLOCK_ADDRESS_BLOCK
DBMS_UTILITYDATA_BLOCK_ADDRESS_FILE
DBMS_UTILITYDB_VERSION1Y
DBMS_UTILITYDB_VERSION2Y
DBMS_UTILITYDIRECTORY_HAS_SYMLINK
DBMS_UTILITYEXEC_DDL_STATEMENTY
DBMS_UTILITYEXPAND_SQL_TEXT
DBMS_UTILITYFORMAT_CALL_STACK
DBMS_UTILITYFORMAT_ERROR_BACKTRACE
DBMS_UTILITYFORMAT_ERROR_STACK
DBMS_UTILITYGET_CPU_TIME
DBMS_UTILITYGET_DEPENDENCY
DBMS_UTILITYGET_ENDIANNESS
DBMS_UTILITYGET_HASH_VALUE
DBMS_UTILITYGET_PARAMETER_VALUE
DBMS_UTILITYGET_SQL_HASH
DBMS_UTILITYGET_TIME
DBMS_UTILITYGET_TZ_TRANSITIONS
DBMS_UTILITYINIT_NUMBER_ARRAY
DBMS_UTILITYINVALIDATE
DBMS_UTILITYIS_BIT_SET
DBMS_UTILITYIS_CLUSTER_DATABASE
DBMS_UTILITYMAKE_DATA_BLOCK_ADDRESS
DBMS_UTILITYNAME_RESOLVE
DBMS_UTILITYNAME_TOKENIZE
DBMS_UTILITYOLD_CURRENT_SCHEMA
DBMS_UTILITYOLD_CURRENT_USER
DBMS_UTILITYPORT_STRING
DBMS_UTILITYSQLID_TO_SQLHASH
DBMS_UTILITYTABLE_TO_COMMA1
DBMS_UTILITYTABLE_TO_COMMA2
DBMS_UTILITYVALIDATE1
DBMS_UTILITYVALIDATE2
DBMS_UTILITYWAIT_ON_PENDING_DML
DIUTILATTRIBUTE_USE_STATISTICS
DIUTILBOOL_TO_INT
DIUTILGET_D
DIUTILGET_DIANA
DIUTILINT_TO_BOOL
DIUTILNODE_USE_STATISTICS
DIUTILSUBPTXT
SQLJUTLBOOL2INT
SQLJUTLCHAR2IDS
SQLJUTLCHAR2IYM
SQLJUTLGET_TYPECODE
SQLJUTLHAS_DEFAULT
SQLJUTLIDS2CHAR
SQLJUTLINT2BOOL
SQLJUTLIYM2CHAR
SQLJUTLURI2VCHAR
UTL_ENCODEBASE64_DECODE完成20220203
UTL_ENCODEBASE64_ENCODE完成20220203
UTL_ENCODEMIMEHEADER_DECODE
UTL_ENCODEMIMEHEADER_ENCODE
UTL_ENCODEQUOTED_PRINTABLE_DECODE
UTL_ENCODEQUOTED_PRINTABLE_ENCODE
UTL_ENCODETEXT_DECODE
UTL_ENCODETEXT_ENCODE
UTL_ENCODEUUDECODE
UTL_ENCODEUUENCODE
UTL_I18NENCODE_SQL_XML
UTL_I18NESCAPE_REFERENCE
UTL_I18NGET_COMMON_TIME_ZONES
UTL_I18NGET_DEFAULT_CHARSET
UTL_I18NGET_DEFAULT_ISO_CURRENCY
UTL_I18NGET_DEFAULT_LINGUISTIC_SORT
UTL_I18NGET_LOCAL_LANGUAGES
UTL_I18NGET_LOCAL_LINGUISTIC_SORTS
UTL_I18NGET_LOCAL_TERRITORIES
UTL_I18NGET_LOCAL_TIME_ZONES
UTL_I18NGET_MAX_CHARACTER_SIZE
UTL_I18NGET_TRANSLATION
UTL_I18NMAP_CHARSET
UTL_I18NMAP_FROM_SHORT_LANGUAGE
UTL_I18NMAP_LANGUAGE_FROM_ISO
UTL_I18NMAP_LOCALE_TO_ISO
UTL_I18NMAP_TERRITORY_FROM_ISO
UTL_I18NMAP_TO_SHORT_LANGUAGE
UTL_I18NRAW_TO_CHAR1
UTL_I18NRAW_TO_CHAR2
UTL_I18NRAW_TO_NCHAR1
UTL_I18NRAW_TO_NCHAR2
UTL_I18NSTRING_TO_RAW
UTL_I18NTRANSLITERATE
UTL_I18NUNESCAPE_REFERENCE
UTL_I18NVALIDATE_CHARACTER_ENCODING2
UTL_I18NVALIDATE_CHARACTER_ENCODING1
UTL_I18NVALIDATE_SQLNAME
UTL_MATCHEDIT_DISTANCE
UTL_MATCHEDIT_DISTANCE_SIMILARITY
UTL_MATCHJARO_WINKLER
UTL_MATCHJARO_WINKLER_SIMILARITY
UTL_RAWBIT_AND
UTL_RAWBIT_COMPLEMENT
UTL_RAWBIT_OR
UTL_RAWBIT_XOR
UTL_RAWCAST_FROM_BINARY_DOUBLE
UTL_RAWCAST_FROM_BINARY_FLOAT
UTL_RAWCAST_FROM_BINARY_INTEGER
UTL_RAWCAST_FROM_NUMBER
UTL_RAWCAST_TO_BINARY_DOUBLE
UTL_RAWCAST_TO_BINARY_FLOAT
UTL_RAWCAST_TO_BINARY_INTEGER
UTL_RAWCAST_TO_NUMBER
UTL_RAWCAST_TO_NVARCHAR2
UTL_RAWCAST_TO_RAW
UTL_RAWCAST_TO_VARCHAR2
UTL_RAWCOMPARE
UTL_RAWCONCAT
UTL_RAWCONVERT
UTL_RAWCOPIES
UTL_RAWLENGTH
UTL_RAWOVERLAY
UTL_RAWREVERSE
UTL_RAWSUBSTR
UTL_RAWTRANSLATE
UTL_RAWTRANSLITERATE
UTL_RAWXRANGE
UTL_URLESCAPE完成20220202
UTL_URLUNESCAPE完成20220202

近期有其他事要忙,进度暂停

项目地址

https://gitee.com/darkathena/opengauss-oracle

20220201更新

年后慢慢开整

0
  1. 支付宝打赏

    qrcode alipay
  2. 微信打赏

    qrcode weixin
博主关闭了所有页面的评论