Oracle Data Mining - Real Time
Prediction
The following sample shows how to use the prediction_probability function.
SELECT
prediction_probability(
CLAS_DT_5_2,
'Yes'
USING
7800 AS bank_funds,
125 AS checking_amount,
20 AS credit_balance,
55 AS age,
'Married' AS marital_status,
250 AS MONEY_MONTLY_OVERDRAWN,
1 AS house_ownership)
FROM
dual;
where:
- CLAS_DT_5_2 is the name of the model,
- Yes is the target value
- the other parameters are a list of attributes used in the model to calculate the probability