tdsql boundless 兼容性改造特征总览

ADD_MONTHS 函数undeclared · minor · ora.func.add_months ALTER SESSION SET 会话参数undeclared · minor · ora.syntax.alter_session 关联数组(INDEX BY 表)undeclared · major · ora.plsql.associative_array AT TIME ZONE 时区表达式undeclared · major · ora.func.at_time_zone 自治事务(PRAGMA AUTONOMOUS_TRANSACTION)undeclared · critical · ora.plsql.autonomous_txn 视图 BEQUEATH 子句undeclared · minor · ora.ddl.bequeath BFILE 外部文件类型undeclared · critical · ora.type.bfile BINARY_FLOAT / BINARY_DOUBLE 类型undeclared · minor · ora.type.binary_float BITAND 函数undeclared · minor · ora.func.bitand BITMAP 位图索引undeclared · major · ora.index.bitmap BULK COLLECT 批量取数undeclared · major · ora.plsql.bulk_collect LENGTHB / SUBSTRB / INSTRB 字节语义函数undeclared · major · ora.func.byte_semantics CDB/多租户与排序规则 DDL 子句(SHARING / DEFAULT COLLATION / CONTAINER_MAP)undeclared · minor · ora.ddl.container_clauses CHAR 定长补空格类型undeclared · minor · ora.type.char_padding Oracle 聚簇表与 CLUSTER 子句undeclared · major · ora.object.cluster_table SQL 层集合运算函数undeclared · major · ora.func.collection_sql 列 DEFAULT 使用序列伪列undeclared · major · ora.column.default_sequence 存储过程内 COMMIT/ROLLBACKundeclared · major · ora.plsql.commit_in_proc 字符串拼接 || 的 NULL 语义undeclared · minor · ora.behavior.concat_null CONNECT BY 层次查询undeclared · critical · ora.syntax.connect_by LEVEL 层次伪列undeclared · major · ora.syntax.level_pseudocolumn CONNECT_BY_ROOT 层次操作符undeclared · major · ora.syntax.connect_by_root 约束 DISABLE 状态undeclared · major · ora.ddl.constraint_disable 游标属性(%FOUND/%NOTFOUND/%ISOPEN/%ROWCOUNT)undeclared · major · ora.plsql.cursor_attributes 游标 FOR 循环undeclared · minor · ora.plsql.cursor_for_loop 日期直接加减数字(天数运算)undeclared · major · ora.behavior.date_arithmetic DATE 类型含时间部分的语义undeclared · major · ora.type.date_semantics 过程体内 DBLINK 引用(obj@link)undeclared · critical · ora.plsql.dblink_in_body, ora.object.dblink_ref DBMS_RANDOM 随机数调用(过程体内)undeclared · minor · ora.pkg.dbms_random, ora.func.dbms_random DBMS_JOB 定时作业调用(过程体内)undeclared · major · ora.pkg.dbms_job, ora.pkg.dbms_scheduler, ora.plsql.dbms_scheduler DECODE 函数undeclared · major · ora.func.decode DEFAULT ON NULL 列默认值undeclared · minor · ora.column.default_on_null DETERMINISTIC 函数标记undeclared · minor · ora.plsql.deterministic DUAL 虚表undeclared · minor · ora.syntax.dual 动态 SQL(EXECUTE IMMEDIATE / DBMS_SQL)undeclared · major · ora.plsql.dynamic_sql EDITIONABLE / NONEDITIONABLE 关键字undeclared · minor · ora.ddl.editionable EMPTY_CLOB / EMPTY_BLOB 函数undeclared · minor · ora.func.empty_lob 与空串字面量的等值/不等比较('' 即 NULL 语义)undeclared · critical · ora.behavior.empty_string_compare EXCEPTION 异常处理块undeclared · minor · ora.plsql.exception_block 显式游标声明(CURSOR ... IS)undeclared · minor · ora.plsql.cursor_explicit Java/C 外部语言存储例程undeclared · critical · ora.plsql.external_routine 外部表(ORGANIZATION EXTERNAL)undeclared · critical · ora.object.external_table FLASHBACK 查询(AS OF SCN/TIMESTAMP、VERSIONS BETWEEN)undeclared · major · ora.syntax.flashback_query SELECT ... FOR UPDATE OF 列级锁定写法undeclared · minor · ora.syntax.for_update_of FOR UPDATE WAIT n 超时等待子句undeclared · minor · ora.syntax.for_update_wait FORALL 批量 DMLundeclared · major · ora.plsql.forall CREATE FORCE VIEWundeclared · minor · ora.ddl.view_force Oracle Text 全文索引与 CTX 包undeclared · critical · ora.index.fulltext_context PL/SQL 代码中的全角标点undeclared · major · ora.plsql.fullwidth_punctuation MDSYS / SDO 空间类型与包undeclared · critical · ora.func.gis_sdo 全局临时表(GLOBAL TEMPORARY TABLE)undeclared · major · ora.object.gtt GOTO 语句undeclared · major · ora.plsql.goto GREATEST / LEAST 函数(NULL 传播差异)undeclared · major · ora.func.greatest_least GROUP_ID / GROUPING_ID 分组函数undeclared · minor · ora.func.grouping_id 对象/列标识符长度超过目标限制undeclared · minor · ora.limit.identifier_length IDENTITY 自增列undeclared · minor · ora.column.identity 单表索引数超过目标限制undeclared · minor · ora.limit.index_count INSERT ALL / INSERT FIRST 多表插入undeclared · major · ora.syntax.insert_all INSTR 函数(3/4 参数形态)undeclared · major · ora.func.instr_multiparam NUMTOYMINTERVAL / NUMTODSINTERVAL / TO_YMINTERVAL / TO_DSINTERVALundeclared · minor · ora.func.interval_conversion INTERVAL 自动分区undeclared · major · ora.partition.interval INTERVAL YEAR TO MONTH / DAY TO SECOND 类型undeclared · minor · ora.type.interval_columns 不可见列(INVISIBLE COLUMN)undeclared · minor · ora.column.invisible 索引组织表(ORGANIZATION INDEX)undeclared · major · ora.object.iot KEEP (DENSE_RANK FIRST/LAST) 聚合子句undeclared · major · ora.func.keep_dense_rank LAST_DAY 函数undeclared · minor · ora.func.last_day LISTAGG 聚合函数undeclared · major · ora.func.listagg LNNVL 函数undeclared · minor · ora.func.lnnvl LONG / LONG RAW 列类型undeclared · major · ora.type.long LPAD / RPAD 函数(NULL 与多字节行为)undeclared · minor · ora.func.pad 物化视图(MATERIALIZED VIEW)undeclared · major · ora.object.mview MEDIAN 聚合函数undeclared · minor · ora.func.median MERGE INTO 语句undeclared · major · ora.syntax.merge_into MERGE INTO 目标为内联视图undeclared · major · ora.ddl.merge_into_view MERGE 的 UPDATE ... DELETE WHERE 组合子句undeclared · major · ora.syntax.merge_update_delete MINUS 集合操作符undeclared · minor · ora.syntax.minus SELECT MODEL 子句undeclared · critical · ora.syntax.model_clause MONTHS_BETWEEN 函数undeclared · minor · ora.func.months_between MyBatis ${} 拼接对象名(表名/FROM/JOIN 位)undeclared · critical · ora.app.mybatis_dollar_object, ora.app.mybatis_dollar_orderby NCHAR / NVARCHAR2 国家字符集类型undeclared · minor · ora.type.national_char

社群/联系

迁移卡住时,带着案例找人复核

企业微信群、1v1 咨询和邮箱入口并列放置;二维码由站长配置,未配置时保留占位。

企业微信群活码 二维码待配置

适合迁移报错、SQL 改写和规则覆盖讨论。

企业微信 1v1 咨询 二维码待配置

适合完整代码库扫描、私有化部署和 PoC 复核。

公众号关注码 二维码待配置

用于沉淀 Oracle 去 O、PL/SQL 迁移和国产库避坑内容。

邮箱咨询

m01dm01db01@foxmail.com

发源库、目标库、代码规模和已脱敏案例短链,便于估算改造工作量。