44 SQL Scoring Functions

Oracle Machine Learning for SQL functions are single-row functions that use OML4SQL to score data. The functions can apply a mining model schema object to the data, or they can dynamically mine the data by executing an analytic clause.

Note:

For a description of the syntax diagrams for these functions, see How to Read Syntax Diagrams in Oracle Database SQL Language Reference

• CLUSTER_DETAILS

• CLUSTER_DISTANCE

• CLUSTER_ID

• CLUSTER_PROBABILITY

• CLUSTER_SET

• FEATURE_COMPARE

• FEATURE_DETAILS

• FEATURE_ID

• FEATURE_SET

• FEATURE_VALUE

• ORA_DM_PARTITION_NAME

• PREDICTION

• PREDICTION_BOUNDS

• PREDICTION_COST

• PREDICTION_DETAILS

• PREDICTION_PROBABILITY

• PREDICTION_SET

• VECTOR_EMBEDDING