Language: PL/SQL Highlight Mode: PHP Last Modified: March 07th, 2009
CLUSTER_PROBABILITY ([ schema .] model
[, cluster_id ] mining_attribute_clause )
FROM (SELECT cust_id, CLUSTER_PROBABILITY(km_sh_clus_sample,2 USING *) prob
ORDER BY prob DESC)
WHERE ROWNUM <11;/*
For cluster_id, specify the identifier of the cluster in the
model. The function returns the probability for the specified
cluster. If you omit this clause, then the function returns
the probability associated with the best predicted cluster.
You can use the form without cluster_id in conjunction with
the CLUSTER_ID function to obtain the best predicted pair of
cluster ID and probability.
The mining_attribute_clause behaves as described for the
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.