OBIEE RPD开发-数据库功能

[ DATA_SOURCE_FEATURE  ORACLE_11g ] 特性值MAX_TABLES_IN_SELECT1024MAX_COLUMNS_IN_GROUP_BY1024MAX_COLUMNS_IN_ORDER_BY1024MAX_COLUMNS_IN_INDEX30PERF_PREFER_COMPRESSION NoIS_COMPRESSION_SUPPORTED YesIS_EHCC_SUPPORTED NoIS_INMEMORY_SUPPORTED NoCONVERT_BIG_INT_BITMASK 0x00000000CONVERT_BINARY_BITMASK 0x00000000CONVERT_BIT_BITMASK 0x00000000CONVERT_CHAR_BITMASK 0x000208FECONVERT_DATE_BITMASK 0x00000000CONVERT_DECIMAL_BITMASK 0x00000001CONVERT_DOUBLE_BITMASK 0x000031FFCONVERT_FLOAT_BITMASK 0x000031FFCONVERT_INTEGER_BITMASK 0x00020001CONVERT_LONG_VAR_BINARY_BITMASK 0x00000000CONVERT_LONG_VAR_CHAR_BITMASK 0x00000000CONVERT_NUMERIC_BITMASK 0x00000001CONVERT_REAL_BITMASK 0x00000001CONVERT_SMALL_INT_BITMASK 0x00020001CONVERT_TIME_BITMASK 0x00000000CONVERT_TIMESTAMP_BITMASK 0x00002019CONVERT_TINY_INT_BITMASK 0x00020001CONVERT_VAR_BINARY_BITMASK 0x00000001CONVERT_VAR_CHAR_BITMASK 0x00000000IS_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 YesIS_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 YesIS_COMPARISON_SUBQUERY_SUPPORTED YesIS_EXISTS_SUBQUERY_SUPPORTED YesIS_IN_SUBQUERY_SUPPORTED YesIS_QUANTIFIED_SUBQUERY_SUPPORTED YesIS_SUBQUERY_IN_CASE_SUPPORTED YesIS_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 YesIS_PERCENTILE_SUPPORTED No IS_MOVING_AVG_SUPPORTED No IS_TOPN_SUPPORTED Yes IS_BOTTOMN_SUPPORTED Yes IS_RUNNING_COUNT_SUPPORTED YesIS_GROUP_BY_SUPPORTED YesIS_GROUP_BY_EXPR_SUPPORTED Yes IS_GROUP_BY_GROUPING_SETS_SUPPORTED YesIS_HAVING_SUPPORTED Yes IS_CASE_LOOK_UP_SUPPORTED Yes IS_CASE_IF_SUPPORTED Yes IS_NULLIF_SUPPORTED YesIS_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 NoIS_RTRIM_SUPPORTED NoIS_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 YesIS_CAST_SUPPORTED YesIS_PARAMETERS_IN_HAVING_CLAUSE_SUPPORTED NoIDENTIFIER_QUOTE_CHAR ''IS_ORDERBY_SUPPORTED Yes IS_DISTINCT_SUPPORTED Yes IS_EXPRESSIONS_IN_ORDERBY_SUPPORTED NoIS_ORDER_BY_COLUMNS_IN_SELECT_SUPPORTED NOFRACTIONAL_SECOND_PRECISION0MAX_ENTRIES_PER_IN_LIST1000MAX_PARAMETERS_PER_DRIVE_JOIN100MAX_QUERIES_PER_DRIVE_JOIN200PERF_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 YesIS_WITH_CLAUSE_SUPPORTED YesIS_CREATE_VIEW_SUPPORTED Yes IS_QUALIFIED_DATA_REFERENCE_SUPPORTED NoIS_DUAL_TABLE_SUPPORTED YesIS_NESTED_ORDERBY_SUPPORTED" YesIS_ROWNUM_LIMIT_SUPPORTED YesIS_ROWNUM_OFFSET_SUPPORTED YesIS_COALESCE_SUPPORTED YesCOMMENT_START '/*'COMMENT_END '*/'PERF_PREFER_MINIMAL_WITH_USAGE NoPERF_PREFER_INTERNAL_STITCH_JOIN NoPREFERS_NATIVE_NULLS_EQUAL_COMPARISON YesMIN_BULK_FETCH_BUFFER_SIZE32768MAX_BULK_FETCH_BUFFER_SIZE327680DEFAULT_BULK_FETCH_ROW_COUNT100