ALL_MINING_MODELS

Example 2-1 ALL_MINING_MODELS

 describe ALL_MINING_MODELS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(128)
 MODEL_NAME                                NOT NULL VARCHAR2(128)
 MINING_FUNCTION                                    VARCHAR2(30)
 ALGORITHM                                          VARCHAR2(30)
 CREATION_DATE                             NOT NULL DATE
 BUILD_DURATION                                     NUMBER
 MODEL_SIZE                                         NUMBER
 PARTITIONED                                        VARCHAR2(3)
 COMMENTS                                           VARCHAR2(4000)

The following query returns the models accessible to you that use the Support Vector Machine algorithm.

SELECT mining_function, model_name
    FROM all_mining_models
    WHERE algorithm = 'SUPPORT_VECTOR_MACHINES'
    ORDER BY mining_function, model_name;

MINING_FUNCTION           MODEL_NAME                                            
------------------------- --------------------                                  
CLASSIFICATION            PART2_CLAS_SAMPLE                                     
CLASSIFICATION            PART_CLAS_SAMPLE                                      
CLASSIFICATION            SVMC_SH_CLAS_SAMPLE                                   
CLASSIFICATION            SVMO_SH_CLAS_SAMPLE                                   
CLASSIFICATION            T_SVM_CLAS_SAMPLE                                     
REGRESSION                SVMR_SH_REGR_SAMPLE