ORA_DM_PARTITION_NAME
mining_attribute_clause::=
Purpose
ORA_DM_PARTITION_NAME
is a single row function that works along with other existing functions. This function returns the name of the partition associated with the input row. When ORA_DM_PARTITION_NAME
is used on a non-partitioned model, the result is NULL
.
The syntax of the ORA_DM_PARTITION_NAME
function can use an optional GROUPING
hint when scoring a partitioned model. See GROUPING Hint.
mining_attribute_clause
The mining_attribute_clause
identifies the column attributes to use as predictors for scoring. When the function is invoked with the analytic syntax, these predictors are also used for building the transient models. The mining_attribute_clause
behaves as described for the PREDICTION
function. See mining_attribute_clause.
See Also:
-
Oracle Data Mining User's Guide for information about scoring
-
Oracle Data Mining Concepts for information about clustering
Note:
The following examples are excerpted from the Data Mining sample programs. For more information about the sample programs, see Appendix A in Oracle Data Mining User's Guide.
Example
SELECT prediction(mymodel using *) pred, ora_dm_partition_name(mymodel USING *) pname FROM customers;