OBIEE RPD开发-数据库功能

[ 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