Example 2-1 describes USER_MINING_MODELS
and shows a sample query.
Example 2-1 USER_MINING_MODELS
describe user_mining_models Name Null? Type -------------------------------- -------- ---------------------- MODEL_NAME NOT NULL VARCHAR2(128) MINING_FUNCTION VARCHAR2(30) ALGORITHM VARCHAR2(30) CREATION_DATE NOT NULL DATE BUILD_DURATION NUMBER MODEL_SIZE NUMBER COMMENTS VARCHAR2(4000)
The following query returns the models in the user's schema that use the Support Vector Machine algorithm.
SELECT mining_function, model_name, algorithm FROM user_mining_models WHERE algorithm IN 'SUPPORT_VECTOR_MACHINES' ORDER BY mining_function; MINING_FUNCTION MODEL_NAME ALGORITHM ------------------------- -------------------- ------------------------------ CLASSIFICATION SVMO_SH_CLAS_SAMPLE SUPPORT_VECTOR_MACHINES CLASSIFICATION T_SVM_CLAS_SAMPLE SUPPORT_VECTOR_MACHINES CLASSIFICATION SVMC_SH_CLAS_SAMPLE SUPPORT_VECTOR_MACHINES REGRESSION SVMR_SH_REGR_SAMPLE SUPPORT_VECTOR_MACHINES
See Also:
ALL_MINING_MODELS
in Oracle Database Reference