Oracle DBMS_DM_UTIL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Data Mining internal utility
AUTHID CURRENT_USER
Dependencies
DBMS_DATA_MINING DBMS_SYS_ERROR ODM_CLUSTERING_UTIL
DBMS_DATA_MINING_INTERNAL DMP_SEC ODM_MODEL_UTIL
DBMS_DM_MODEL_IMP DMP_SYS ODM_UTIL
DBMS_SESSION ODM_ASSOCIATION_RULE_MODEL  
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with ? granted to ???
Source {ORACLE_HOME}/rdbms/admin/prvtdmmi.plb
Subprograms
 
ASSERT
Undocumented dbms_dm_util.assert(
cond   IN BOOLEAN,
exec   IN NUMBER,
param1 IN VARCHAR2,
param2 IN VARCHAR2,
param3 IN VARCHAR2);
TBD
 
BIC
Undocumented

Valid msk values appear to be 1, 2, and 3
dbms_dm_util.bic(
val IN OUT NUMBER,
msk IN     NUMBER);
DECLARE
 ioval NUMBER := 99;
BEGIN
  dbms_dm_util.bic(ioval, 1);
  dbms_output.put_line(ioval);
END;
/


-- returns 98
 
BIF
Undocumented

There is a wide range of valid msk values
dbms_dm_util.bif(
val IN OUT NUMBER,
msk IN     NUMBER);
DECLARE
 ioval NUMBER := 99;
BEGIN
  dbms_dm_util.bif(ioval, 100);
  dbms_output.put_line(ioval);
END;
/


-- returns 199
 
BIS
Undocumented

There is a wide range of valid msk values
dbms_dm_util.bis(
val IN OUT NUMBER,
msk IN     NUMBER);
DECLARE
 ioval NUMBER := 99;
BEGIN
  dbms_dm_util.bis(ioval, 10);
  dbms_output.put_line(ioval);
END;
/


-- returns 109
 
BIT
Undocumented

The range of valid msk values appears to be 0 to 3
dbms_dm_util.bit(
val IN NUMBER,
msk IN NUMBER)
RETURN BOOLEAN;
BEGIN
  IF dbms_dm_util.bit(99, 3) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/


-- returns T with msk values from 0 to 3: Else F
 
NUMVAL
Undocumented

Tried many strings none returned a value
dbms_dm_util.numval(str IN VARCHAR2) RETURN NUMBER;
DECLARE
 retval NUMBER(20,10);
BEGIN
  retval := dbms_dm_util.numval('One Hundred');
  dbms_output.put_line(TO_CHAR(retval));
END;
/
 
USER_TABLE_EXISTS
Returns TRUE if a table exists dbms_dm_util.user_table_exists(
schema IN VARCHAR2,
name   IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF dbms_dm_util.user_table_exists(USER, 'TAB$') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/

Related Topics
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved