1. SQL Language Reference
  2. Functions
  3. ORA_DM_PARTITION_NAME

ORA_DM_PARTITION_NAME

Syntax

Description of ora_dm_partition_name.eps follows
Description of the illustration ora_dm_partition_name.eps

mining_attribute_clause::=

Description of mining_attribute_clause.eps follows
Description of the illustration mining_attribute_clause.eps

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:

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;