[ 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开发-数据库功能
最新推荐文章于 2023-02-10 07:34:30 发布