2 Star 4 Fork 2

DarkAthena/opengauss-oracle

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README
MulanPSL-2.0

opengauss-oracle

2022-01-28 通知

本项目对于不同版本兼容性验证通过后的对象,会合并到compat-tools项目中


介绍

一些函数和包,可以在postgresql中使用oracle中的同名函数,不包含compat-tools(截至到2021-12-28的公开版本)里已存在的

计划及进度

函数
函数名称 功能描述 进度 完成日期 是否已合并至compat-tools
ANY_VALUE 聚合函数,取任意值 完成 20220101
ASCIISTR 获得字符串的ascii码 完成 20211229
BFILENAME 获得操作系统上的一个文件作为对象
BIN_TO_NUM 二进制转数字 完成 20211229
COSH 双曲余弦 完成 20211230
KURTOSIS_POP 总体峰态 完成 20220103
KURTOSIS_SAMP 样本峰态 完成 20220103
LNNVL 避免表达式中有空值导致统计遗漏的一个函数 完成 20220101
NUMTOYMINTERVAL 将数字转换成年月INTERVAL 完成 20211230
RATIO_TO_REPORT 分析函数,取本值占分组的百分比
ROUND_TIES_TO_EVEN (number) 区别于round的另一种四舍五入 完成 20211229
SINH 双曲正弦 完成 20211230
SKEWNESS_POP 总体偏度 完成 20220103
SKEWNESS_SAMP 样本偏度 完成 20220103
SOUNDEX 发音相似 完成 20211230
STANDARD_HASH 标准哈希 完成 20211229
SYSTIMESTAMP 当前时间戳 完成 20211229
TANH 双曲正切 完成 20211230
UNISTR 将unicode编码转换成文字字符串 完成 20211229
以下为相较于第一版的新增部分
BIT_AND_AGG 位与聚合 完成 20211231
BIT_OR_AGG 位或聚合 完成 20211231
BIT_XOR_AGG 位异或聚合 完成 20211231
REMAINDER 取任何数相除的余数(和mod不一样,不会进行floor) 完成 20220102
BITOR 位或 完成 20211231
BITXOR 位异或 完成 20211231
NLS_CHARSET_ID 获取字符集ID 完成 20220506
NLS_CHARSET_NAME 获取字符集名称 完成 20220506
202200824新增
DUMP 获取值的二进制数据 完成 20220824

下列包名为我初次筛选,在开发中可能会用到的包

包名 主要功能 compat-tools是否已含 本人是否可能会进行开发 本人开发进度 本人完成日期
DBMS_HADOOP 在数据库中集成对HIVE及HADOOP进行操作、查询的功能 N
DBMS_JOB 作业管理 Y N
DBMS_LOB 大对象操作包 Y 80%
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 完成 20220212
UTL_ENCODE MIMEHEADER_ENCODE 完成 20220212
UTL_ENCODE QUOTED_PRINTABLE_DECODE 完成 20220212
UTL_ENCODE QUOTED_PRINTABLE_ENCODE 完成 20220212
UTL_ENCODE TEXT_DECODE 完成 20220212
UTL_ENCODE TEXT_ENCODE 完成 20220212
UTL_ENCODE UUDECODE 完成 20220214
UTL_ENCODE UUENCODE 完成 20220214
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 完成 20220206
UTL_RAW BIT_COMPLEMENT 完成 20220206
UTL_RAW BIT_OR 完成 20220206
UTL_RAW BIT_XOR 完成 20220206
UTL_RAW CAST_FROM_BINARY_DOUBLE
UTL_RAW CAST_FROM_BINARY_FLOAT
UTL_RAW CAST_FROM_BINARY_INTEGER 完成 20220208
UTL_RAW CAST_FROM_NUMBER 完成 20220208
UTL_RAW CAST_TO_BINARY_DOUBLE
UTL_RAW CAST_TO_BINARY_FLOAT
UTL_RAW CAST_TO_BINARY_INTEGER 完成 20220208
UTL_RAW CAST_TO_NUMBER 完成 20220208
UTL_RAW CAST_TO_NVARCHAR2
UTL_RAW CAST_TO_RAW 完成 20220203
UTL_RAW CAST_TO_VARCHAR2 完成 20220203
UTL_RAW COMPARE 完成 20220205
UTL_RAW CONCAT 完成 20220203
UTL_RAW CONVERT 完成 20220205
UTL_RAW COPIES 完成 20220204
UTL_RAW LENGTH 完成 20220203
UTL_RAW OVERLAY 完成 20220204
UTL_RAW REVERSE 完成 20220205
UTL_RAW SUBSTR 完成 20220203
UTL_RAW TRANSLATE 完成 20220203
UTL_RAW TRANSLITERATE 完成 20220203
UTL_RAW XRANGE 完成 20220205
UTL_URL ESCAPE 完成 20220202
UTL_URL UNESCAPE 完成 20220202
DBMS_LOB OPEN 完成 20220503
DBMS_LOB ERASE 完成 20220503
DBMS_LOB READ 完成 20220503
DBMS_LOB SUBSTR 完成 20220503
DBMS_LOB APPEND 完成 20220503
DBMS_LOB CLOSE 完成 20220503
DBMS_LOB TRIM 完成 20220503
DBMS_LOB WRITE 完成 20220503
DBMS_LOB GETLENGTH 完成 20220503
DBMS_LOB CREATETEMPORARY 完成 20220503
DBMS_LOB FREETEMPORARY 完成 20220503
DBMS_LOB INSTR 完成 20220503
DBMS_LOB COMPARE 完成 20220503
DBMS_LOB COPY 完成 20220503
DBMS_LOB WRITEAPPEND 完成 20220503
DBMS_LOB convertToClob
DBMS_LOB convertToBlob
DBMS_LOB clob2file
DBMS_CRYPTO hash 部分完成(MD5/SHA256) 20220827

注意事项

1.STANDARD_HASH函数依赖于postgresql-contrib模块中的pgcrypto,但openGauss默认没有此模块,请自行提前安装

木兰宽松许可证, 第2版 木兰宽松许可证, 第2版 2020年1月 http://license.coscl.org.cn/MulanPSL2 您对“软件”的复制、使用、修改及分发受木兰宽松许可证,第2版(“本许可证”)的如下条款的约束: 0. 定义 “软件”是指由“贡献”构成的许可在“本许可证”下的程序和相关文档的集合。 “贡献”是指由任一“贡献者”许可在“本许可证”下的受版权法保护的作品。 “贡献者”是指将受版权法保护的作品许可在“本许可证”下的自然人或“法人实体”。 “法人实体”是指提交贡献的机构及其“关联实体”。 “关联实体”是指,对“本许可证”下的行为方而言,控制、受控制或与其共同受控制的机构,此处的控制是指有受控方或共同受控方至少50%直接或间接的投票权、资金或其他有价证券。 1. 授予版权许可 每个“贡献者”根据“本许可证”授予您永久性的、全球性的、免费的、非独占的、不可撤销的版权许可,您可以复制、使用、修改、分发其“贡献”,不论修改与否。 2. 授予专利许可 每个“贡献者”根据“本许可证”授予您永久性的、全球性的、免费的、非独占的、不可撤销的(根据本条规定撤销除外)专利许可,供您制造、委托制造、使用、许诺销售、销售、进口其“贡献”或以其他方式转移其“贡献”。前述专利许可仅限于“贡献者”现在或将来拥有或控制的其“贡献”本身或其“贡献”与许可“贡献”时的“软件”结合而将必然会侵犯的专利权利要求,不包括对“贡献”的修改或包含“贡献”的其他结合。如果您或您的“关联实体”直接或间接地,就“软件”或其中的“贡献”对任何人发起专利侵权诉讼(包括反诉或交叉诉讼)或其他专利维权行动,指控其侵犯专利权,则“本许可证”授予您对“软件”的专利许可自您提起诉讼或发起维权行动之日终止。 3. 无商标许可 “本许可证”不提供对“贡献者”的商品名称、商标、服务标志或产品名称的商标许可,但您为满足第4条规定的声明义务而必须使用除外。 4. 分发限制 您可以在任何媒介中将“软件”以源程序形式或可执行形式重新分发,不论修改与否,但您必须向接收者提供“本许可证”的副本,并保留“软件”中的版权、商标、专利及免责声明。 5. 免责声明与责任限制 “软件”及其中的“贡献”在提供时不带任何明示或默示的担保。在任何情况下,“贡献者”或版权所有者不对任何人因使用“软件”或其中的“贡献”而引发的任何直接或间接损失承担责任,不论因何种原因导致或者基于何种法律理论,即使其曾被建议有此种损失的可能性。 6. 语言 “本许可证”以中英文双语表述,中英文版本具有同等法律效力。如果中英文版本存在任何冲突不一致,以中文版为准。 条款结束 如何将木兰宽松许可证,第2版,应用到您的软件 如果您希望将木兰宽松许可证,第2版,应用到您的新软件,为了方便接收者查阅,建议您完成如下三步: 1, 请您补充如下声明中的空白,包括软件名、软件的首次发表年份以及您作为版权人的名字; 2, 请您在软件包的一级目录下创建以“LICENSE”为名的文件,将整个许可证文本放入该文件中; 3, 请将如下声明文本放入每个源文件的头部注释中。 Copyright (c) [Year] [name of copyright holder] [Software Name] is licensed under Mulan PSL v2. You can use this software according to the terms and conditions of the Mulan PSL v2. You may obtain a copy of Mulan PSL v2 at: http://license.coscl.org.cn/MulanPSL2 THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. See the Mulan PSL v2 for more details. Mulan Permissive Software License,Version 2 Mulan Permissive Software License,Version 2 (Mulan PSL v2) January 2020 http://license.coscl.org.cn/MulanPSL2 Your reproduction, use, modification and distribution of the Software shall be subject to Mulan PSL v2 (this License) with the following terms and conditions: 0. Definition Software means the program and related documents which are licensed under this License and comprise all Contribution(s). Contribution means the copyrightable work licensed by a particular Contributor under this License. Contributor means the Individual or Legal Entity who licenses its copyrightable work under this License. Legal Entity means the entity making a Contribution and all its Affiliates. Affiliates means entities that control, are controlled by, or are under common control with the acting entity under this License, ‘control’ means direct or indirect ownership of at least fifty percent (50%) of the voting power, capital or other securities of controlled or commonly controlled entity. 1. Grant of Copyright License Subject to the terms and conditions of this License, each Contributor hereby grants to you a perpetual, worldwide, royalty-free, non-exclusive, irrevocable copyright license to reproduce, use, modify, or distribute its Contribution, with modification or not. 2. Grant of Patent License Subject to the terms and conditions of this License, each Contributor hereby grants to you a perpetual, worldwide, royalty-free, non-exclusive, irrevocable (except for revocation under this Section) patent license to make, have made, use, offer for sale, sell, import or otherwise transfer its Contribution, where such patent license is only limited to the patent claims owned or controlled by such Contributor now or in future which will be necessarily infringed by its Contribution alone, or by combination of the Contribution with the Software to which the Contribution was contributed. The patent license shall not apply to any modification of the Contribution, and any other combination which includes the Contribution. If you or your Affiliates directly or indirectly institute patent litigation (including a cross claim or counterclaim in a litigation) or other patent enforcement activities against any individual or entity by alleging that the Software or any Contribution in it infringes patents, then any patent license granted to you under this License for the Software shall terminate as of the date such litigation or activity is filed or taken. 3. No Trademark License No trademark license is granted to use the trade names, trademarks, service marks, or product names of Contributor, except as required to fulfill notice requirements in Section 4. 4. Distribution Restriction You may distribute the Software in any medium with or without modification, whether in source or executable forms, provided that you provide recipients with a copy of this License and retain copyright, patent, trademark and disclaimer statements in the Software. 5. Disclaimer of Warranty and Limitation of Liability THE SOFTWARE AND CONTRIBUTION IN IT ARE PROVIDED WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED. IN NO EVENT SHALL ANY CONTRIBUTOR OR COPYRIGHT HOLDER BE LIABLE TO YOU FOR ANY DAMAGES, INCLUDING, BUT NOT LIMITED TO ANY DIRECT, OR INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING FROM YOUR USE OR INABILITY TO USE THE SOFTWARE OR THE CONTRIBUTION IN IT, NO MATTER HOW IT’S CAUSED OR BASED ON WHICH LEGAL THEORY, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. 6. Language THIS LICENSE IS WRITTEN IN BOTH CHINESE AND ENGLISH, AND THE CHINESE VERSION AND ENGLISH VERSION SHALL HAVE THE SAME LEGAL EFFECT. IN THE CASE OF DIVERGENCE BETWEEN THE CHINESE AND ENGLISH VERSIONS, THE CHINESE VERSION SHALL PREVAIL. END OF THE TERMS AND CONDITIONS How to Apply the Mulan Permissive Software License,Version 2 (Mulan PSL v2) to Your Software To apply the Mulan PSL v2 to your work, for easy identification by recipients, you are suggested to complete following three steps: i Fill in the blanks in following statement, including insert your software name, the year of the first publication of your software, and your name identified as the copyright owner; ii Create a file named “LICENSE” which contains the whole context of this License in the first directory of your software package; iii Attach the statement to the appropriate annotated syntax at the beginning of each source file. Copyright (c) [Year] [name of copyright holder] [Software Name] is licensed under Mulan PSL v2. You can use this software according to the terms and conditions of the Mulan PSL v2. You may obtain a copy of Mulan PSL v2 at: http://license.coscl.org.cn/MulanPSL2 THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. See the Mulan PSL v2 for more details.

About

some function or package for openGauss(a database that base on postgresql) ,and the object's name is same as the oracle's objects expand collapse
Cancel

Releases

No release

Contributors

All

Activities

Load More
can not load any more
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/darkathena/opengauss-oracle.git
git@gitee.com:darkathena/opengauss-oracle.git
darkathena
opengauss-oracle
opengauss-oracle
main

Search

344bd9b3 5694891 D2dac590 5694891