31 个场景候选
Oracle SQL 兼容检查：MATERIALIZE HINToma.obsql.materialize_hint · minor · professionalOracle SQL 兼容检查：AGGREGATE FUNCTIONoma.perf.aggregate_function · info · professionalOracle SQL 兼容检查：DELETE NO WHEREoma.perf.delete_no_where · minor · professionalOracle SQL 兼容检查：JOINED TABLES GT MAXoma.perf.joined_tables_gt_max · minor · professionalOracle SQL 兼容检查：LOGIC OPERATORS GT MAXoma.perf.logic_operators_gt_max · minor · professionalOracle SQL 兼容检查：SELECT NO WHEREoma.perf.select_no_where · minor · professionalOracle SQL 兼容检查：SUBQUERYoma.perf.subquery · info · professionalOracle SQL 兼容检查：UPDATE NO WHEREoma.perf.update_no_where · minor · professionalOracle SQL 兼容检查：WITH SUBQUERY FACTORINGoma.perf.with_subquery_factoring · info · professionalOracle SQL 兼容检查：UNSUPPORTEDoma.sql.hint.unsupported · minor · professionalOracle SQL 治理检查：STATEMENT SELECT NO SELECT ALLperf_static_risk.bb.oracle.statement_select_no_select_all · major · professionalOracle SQL 治理检查：STATEMENT WHERE DISALLOW FUNCTIONS AND CALCULATIONSperf_static_risk.bb.oracle.statement_where_disallow_functions_and_calculations · major · professionalOracle SQL 治理检查：STATEMENT WHERE NO LEADING WILDCARD LIKEperf_static_risk.bb.oracle.statement_where_no_leading_wildcard_like · major · professional逗号连接疑似笛卡尔积perf_static_risk.cartesian_join · major · pending深层嵌套子查询perf_static_risk.deep_nested_subquery · major · pendingDELETE 未带 WHEREperf_static_risk.delete_without_where · major · pendingDISTINCT 与 ORDER BY 同用perf_static_risk.distinct_with_order · minor · pending谓词中函数包裹列perf_static_risk.function_wrapped_column · major · pendingHAVING 承载过滤条件perf_static_risk.having_without_group_selectivity · minor · pending日期列疑似与字符串字面量比较perf_static_risk.implicit_date_string_compare · minor · pending数值列疑似与字符串数字比较perf_static_risk.implicit_number_string_compare · minor · pendingLIKE 前导通配符perf_static_risk.leading_wildcard_like · minor · pendingNOT IN 子查询perf_static_risk.not_in_subquery · minor · pending谓词中 NVL/COALESCE 包裹列perf_static_risk.nvl_on_predicate_column · minor · pendingWHERE 中 OR 条件链过长perf_static_risk.or_chain · minor · pendingROWNUM 限制未伴随 ORDER BYperf_static_risk.rownum_without_order · minor · pendingSELECT 列表中的标量子查询perf_static_risk.scalar_subquery_select · minor · pendingSELECT * 投影perf_static_risk.select_star · minor · pendingUPDATE 未带 WHEREperf_static_risk.update_without_where · major · pendingPRAGMA INLINE 编译内联指令pragma_inline · minor · pendingPRAGMA UDF SQL 调用优化指令pragma_udf · minor · pending