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
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 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.
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.
SELECT prediction(mymodel using *) pred, ora_dm_partition_name(mymodel USING *) pname FROM customers;