Description: CLUSTER_ID returns the cluster identifier of the predicted cluster with the highest probability for the set of predictors specified in the mining_attribute_clause. The value returned is an Oracle NUMBER.
The mining_attribute_clause behaves as described for the PREDICTION function.
This function is for use with clustering models that have been created using the DBMS_DATA_MINING package or with the Oracle Data Mining Java API.
This example, and the prerequisite data mining operations, including the creation of the dm_sh_clus_sample model and the dm_sh_sample_apply_prepared view, can be found in the demo file $ORACLE_HOME/rdbms/demo/dmkmdemo.sql.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
CLUSTER_ID(<schame.model><mining_attribute_clause>)SELECT CLUSTER_ID(km_sh_clus_sample USING *)AS clus,COUNT(*)AS cnt
GROUPBY CLUSTER_ID(km_sh_clus_sample USING *)ORDERBY cnt DESC
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.