| [ DATA_SOURCE_FEATURE ORACLE_11g ] | |
| 特性 | 值 |
| MAX_TABLES_IN_SELECT | 1024 |
| MAX_COLUMNS_IN_GROUP_BY | 1024 |
| MAX_COLUMNS_IN_ORDER_BY | 1024 |
| MAX_COLUMNS_IN_INDEX | 30 |
| PERF_PREFER_COMPRESSION | No |
| IS_COMPRESSION_SUPPORTED | Yes |
| IS_EHCC_SUPPORTED | No |
| IS_INMEMORY_SUPPORTED | No |
| CONVERT_BIG_INT_BITMASK | 0x00000000 |
| CONVERT_BINARY_BITMASK | 0x00000000 |
| CONVERT_BIT_BITMASK | 0x00000000 |
| CONVERT_CHAR_BITMASK | 0x000208FE |
| CONVERT_DATE_BITMASK | 0x00000000 |
| CONVERT_DECIMAL_BITMASK | 0x00000001 |
| CONVERT_DOUBLE_BITMASK | 0x000031FF |
| CONVERT_FLOAT_BITMASK | 0x000031FF |
| CONVERT_INTEGER_BITMASK | 0x00020001 |
| CONVERT_LONG_VAR_BINARY_BITMASK | 0x00000000 |
| CONVERT_LONG_VAR_CHAR_BITMASK | 0x00000000 |
| CONVERT_NUMERIC_BITMASK | 0x00000001 |
| CONVERT_REAL_BITMASK | 0x00000001 |
| CONVERT_SMALL_INT_BITMASK | 0x00020001 |
| CONVERT_TIME_BITMASK | 0x00000000 |
| CONVERT_TIMESTAMP_BITMASK | 0x00002019 |
| CONVERT_TINY_INT_BITMASK | 0x00020001 |
| CONVERT_VAR_BINARY_BITMASK | 0x00000001 |
| CONVERT_VAR_CHAR_BITMASK | 0x00000000 |
| IS_LEFT_OUTER_JOIN_SUPPORTED | Yes |
| IS_RIGHT_OUTER_JOIN_SUPPORTED | Yes |
| IS_FULL_OUTER_JOIN_SUPPORTED | Yes |
| IS_NESTED_OUTER_JOIN_SUPPORTED | Yes |
| IS_DERIVED_TABLES_SUPPORTED | Yes |
| IS_CORRELATION_NAME_SUPPORTED | Yes |
| IS_UNION_SUPPORTED | Yes |
| IS_UNION_ALL_SUPPORTED | Yes |
| IS_EXCEPT_ALL_SUPPORTED | No |
| IS_EXCEPT_SUPPORTED | Yes |
| IS_INTERSECT_ALL_SUPPORTED | No |
| IS_INTERSECT_SUPPORTED | Yes |
| IS_PREDICATE_SCALAR_SUBQUERY_SUPPORTED | Yes |
| IS_VALUE_SUBQUERY_SUPPORTED | Yes |
| IS_CORRELATED_SUBQUERY_SUPPORTED | Yes |
| IS_COMPARISON_SUBQUERY_SUPPORTED | Yes |
| IS_EXISTS_SUBQUERY_SUPPORTED | Yes |
| IS_IN_SUBQUERY_SUPPORTED | Yes |
| IS_QUANTIFIED_SUBQUERY_SUPPORTED | Yes |
| IS_SUBQUERY_IN_CASE_SUPPORTED | Yes |
| IS_COUNT_SUPPORTED | Yes |
| IS_COUNT_DISTINCT_SUPPORTED | Yes |
| IS_COUNT_STAR_SUPPORTED | Yes |
| IS_SUM_SUPPORTED | Yes |
| IS_AVG_SUPPORTED | Yes |
| IS_MIN_SUPPORTED | Yes |
| IS_MAX_SUPPORTED | Yes |
| IS_FIRST_SUPPORTED | Yes |
| IS_LAST_SUPPORTED | Yes |
| IS_RANK_SUPPORTED | Yes |
| IS_DENSE_RANK_SUPPORTED | Yes |
| IS_PERCENTILE_SUPPORTED | No |
| IS_MOVING_AVG_SUPPORTED | No |
| IS_TOPN_SUPPORTED | Yes |
| IS_BOTTOMN_SUPPORTED | Yes |
| IS_RUNNING_COUNT_SUPPORTED | Yes |
| IS_GROUP_BY_SUPPORTED | Yes |
| IS_GROUP_BY_EXPR_SUPPORTED | Yes |
| IS_GROUP_BY_GROUPING_SETS_SUPPORTED | Yes |
| IS_HAVING_SUPPORTED | Yes |
| IS_CASE_LOOK_UP_SUPPORTED | Yes |
| IS_CASE_IF_SUPPORTED | Yes |
| IS_NULLIF_SUPPORTED | Yes |
| IS_DATE_LITERAL_SUPPORTED | Yes |
| IS_TIME_LITERAL_SUPPORTED | Yes |
| IS_DATE_TIME_LITERAL_SUPPORTED | Yes |
| IS_INTERVAL_LITERAL_SUPPORTED | No |
| IS_CALENDAR_EXTRACT_DAY_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_DAY_OF_QUARTER_SUPPORTED | No |
| IS_CALENDAR_EXTRACT_DAY_OF_YEAR_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_HOUR_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_MINUTE_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_MONTH_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_MONTH_OF_QUARTER_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_QUARTER_OF_YEAR_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_SECOND_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_WEEK_OF_QUARTER_SUPPORTED | No |
| IS_CALENDAR_EXTRACT_WEEK_OF_YEAR_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_YEAR_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_WEEK_OF_MONTH_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_SHORT_NAME_OF_MONTH_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_LONG_NAME_OF_MONTH_SUPPORTED | No |
| IS_CALENDAR_EXTRACT_DAY_OF_WEEK_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_SHORT_NAME_OF_DAY_SUPPORTED | Yes |
| IS_CALENDAR_EXTRACT_LONG_NAME_OF_DAY_SUPPORTED | No |
| IS_FISCAL_EXTRACT_DAY_SUPPORTED | No |
| IS_FISCAL_EXTRACT_DAY_OF_QUARTER_SUPPORTED | No |
| IS_FISCAL_EXTRACT_DAY_OF_YEAR_SUPPORTED | No |
| IS_FISCAL_EXTRACT_HOUR_SUPPORTED | No |
| IS_FISCAL_EXTRACT_MINUTE_SUPPORTED | No |
| IS_FISCAL_EXTRACT_MONTH_SUPPORTED | No |
| IS_FISCAL_EXTRACT_MONTH_OF_QUARTER_SUPPORTED | No |
| IS_FISCAL_EXTRACT_QUARTER_OF_YEAR_SUPPORTED | No |
| IS_FISCAL_EXTRACT_SECOND_SUPPORTED | No |
| IS_FISCAL_EXTRACT_WEEK_OF_QUARTER_SUPPORTED | No |
| IS_FISCAL_EXTRACT_WEEK_OF_YEAR_SUPPORTED | No |
| IS_FISCAL_EXTRACT_YEAR_SUPPORTED | No |
| IS_FISCAL_EXTRACT_WEEK_OF_MONTH_SUPPORTED | No |
| IS_FISCAL_EXTRACT_SHORT_NAME_OF_MONTH_SUPPORTED | No |
| IS_FISCAL_EXTRACT_LONG_NAME_OF_MONTH_SUPPORTED | No |
| IS_FISCAL_EXTRACT_DAY_OF_WEEK_SUPPORTED | No |
| IS_FISCAL_EXTRACT_SHORT_NAME_OF_DAY_SUPPORTED | No |
| IS_FISCAL_EXTRACT_LONG_NAME_OF_DAY_SUPPORTED | No |
| IS_CHAR_LENGTH_SUPPORTED | Yes |
| IS_BIT_LENGTH_SUPPORTED | No |
| IS_OCTET_LENGTH_SUPPORTED | No |
| IS_POSITION_SUPPORTED | Yes |
| IS_LOCATE_SUPPORTED | Yes |
| IS_ASCII_SUPPORTED | Yes |
| IS_LENGTH_SUPPORTED | No |
| IS_EXP_SUPPORTED | Yes |
| IS_POWER_SUPPORTED | Yes |
| IS_SQRT_SUPPORTED | Yes |
| IS_CEILING_SUPPORTED | Yes |
| IS_FLOOR_SUPPORTED | Yes |
| IS_ROUND_SUPPORTED | Yes |
| IS_TRUNCATE_SUPPORTED | Yes |
| IS_SIGN_SUPPORTED | Yes |
| IS_ABS_SUPPORTED | Yes |
| IS_MOD_SUPPORTED | Yes |
| IS_MODF_SUPPORTED | No |
| IS_RAND_SUPPORTED | No |
| IS_LOG_SUPPORTED | Yes |
| IS_LOG10_SUPPORTED | Yes |
| IS_PI_SUPPORTED | No |
| IS_DEGREES_SUPPORTED | No |
| IS_RADIANS_SUPPORTED | No |
| IS_SIN_SUPPORTED | Yes |
| IS_COS_SUPPORTED | Yes |
| IS_TAN_SUPPORTED | Yes |
| IS_COT_SUPPORTED | No |
| IS_ASIN_SUPPORTED | Yes |
| IS_ACOS_SUPPORTED | Yes |
| IS_ATAN_SUPPORTED | Yes |
| IS_ATAN2_SUPPORTED | Yes |
| IS_SINH_SUPPORTED | Yes |
| IS_COSH_SUPPORTED | Yes |
| IS_TANH_SUPPORTED | Yes |
| IS_TRIM_SUPPORTED | Yes |
| IS_LTRIM_SUPPORTED | No |
| IS_RTRIM_SUPPORTED | No |
| IS_UPPER_SUPPORTED | Yes |
| IS_LOWER_SUPPORTED | Yes |
| IS_CONCAT_SUPPORTED | Yes |
| IS_SUBSTRING_SUPPORTED | Yes |
| IS_REPLACE_SUPPORTED | Yes |
| IS_INSERT_SUPPORTED | No |
| IS_LEFT_SUPPORTED | Yes |
| IS_RIGHT_SUPPORTED | Yes |
| IS_SPACE_SUPPORTED | Yes |
| IS_REPEAT_SUPPORTED | No |
| IS_CHAR_SUPPORTED | Yes |
| IS_TIMESTAMP_ADD_SUPPORTED | Yes |
| IS_TIMESTAMP_DIFF_SUPPORTED | Yes |
| IS_DATABASE_SUPPORTED | No |
| IS_IFNULL_SUPPORTED | Yes |
| IS_USER_SUPPORTED | No |
| IS_CONVERT_SUPPORTED | No |
| IS_IS_NULL_SUPPORTED | Yes |
| IS_BETWEEN_SUPPORTED | Yes |
| IS_LIKE_SUPPORTED | Yes |
| IS_LIKE_ESCAPE_CLAUSE_SUPPORTED | Yes |
| IS_IN_SUPPORTED | Yes |
| IS_MULTICOLUMN_IN_SUPPORTED | Yes |
| IS_MULTIPLE_STATEMENTS_PER_CONNECTION_SUPPORTED | Yes |
| IS_NULL_VALUES_SORT_FIRST | No |
| IS_NULLS_SORT_DIRECTION_IN_ORDERBY_SUPPORTED | Yes |
| IS_CAST_SUPPORTED | Yes |
| IS_PARAMETERS_IN_HAVING_CLAUSE_SUPPORTED | No |
| IDENTIFIER_QUOTE_CHAR | '' |
| IS_ORDERBY_SUPPORTED | Yes |
| IS_DISTINCT_SUPPORTED | Yes |
| IS_EXPRESSIONS_IN_ORDERBY_SUPPORTED | No |
| IS_ORDER_BY_COLUMNS_IN_SELECT_SUPPORTED | NO |
| FRACTIONAL_SECOND_PRECISION | 0 |
| MAX_ENTRIES_PER_IN_LIST | 1000 |
| MAX_PARAMETERS_PER_DRIVE_JOIN | 100 |
| MAX_QUERIES_PER_DRIVE_JOIN | 200 |
| PERF_PREFER_IN_LISTS | Yes |
| IS_SQL89_COLUMN_ALIAS_CONFORMANCE_SUPPORTED | No |
| IS_MEDIAN_SUPPORTED | Yes |
| IS_NTILE_SUPPORTED | No |
| IS_STDDEV_POP_DISTINCT_SUPPORTED | No |
| IS_STDDEV_POP_SUPPORTED | Yes |
| IS_STDDEV_SAMP_DISTINCT_SUPPORTED | No |
| IS_STDDEV_SAMP_SUPPORTED | Yes |
| IS_CREATE_AS_SELECT_SUPPORTED | Yes |
| IS_INSERT_SELECT_SUPPORTED | Yes |
| IS_SUBTOTALLING_SUPPORTED | Yes |
| IS_ROWNUM_SUPPORTED | Yes |
| IS_WITH_CLAUSE_SUPPORTED | Yes |
| IS_CREATE_VIEW_SUPPORTED | Yes |
| IS_QUALIFIED_DATA_REFERENCE_SUPPORTED | No |
| IS_DUAL_TABLE_SUPPORTED | Yes |
| IS_NESTED_ORDERBY_SUPPORTED" | Yes |
| IS_ROWNUM_LIMIT_SUPPORTED | Yes |
| IS_ROWNUM_OFFSET_SUPPORTED | Yes |
| IS_COALESCE_SUPPORTED | Yes |
| COMMENT_START | '/*' |
| COMMENT_END | '*/' |
| PERF_PREFER_MINIMAL_WITH_USAGE | No |
| PERF_PREFER_INTERNAL_STITCH_JOIN | No |
| PREFERS_NATIVE_NULLS_EQUAL_COMPARISON | Yes |
| MIN_BULK_FETCH_BUFFER_SIZE | 32768 |
| MAX_BULK_FETCH_BUFFER_SIZE | 327680 |
| DEFAULT_BULK_FETCH_ROW_COUNT | 100 |
OBIEE RPD开发-数据库功能
最新推荐文章于 2025-06-23 16:02:51 发布
本文详细介绍了 Oracle 11g 数据库的各项特性参数，包括支持的最大选择表数量、最大分组列数、最大索引列数等关键配置。此外，还概述了各种数据类型转换的支持情况及多种查询优化选项。
扫一扫
81
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
