Data Science Using Oracle Data Miner and Oracle R Enterprise by Sibanjan Das

Author:Sibanjan Das
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

BEGIN

LOG_MESSAGE('START OF '||G_PACKAGE_NAME||'.'||l_method_name);

-- Invokes ORE function BuildAssocValRules and insert the results into table DEMO_ASSOC_RULES_RES

l_insert_sql := 'INSERT INTO '||l_output_table||'(RESULT_ID,MODEL_TYPE,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,RULES,SUPPORT,CONFIDENCE,LIFT) '||' SELECT DEMO_ASSOC_RULES_S.NEXTVAL'||',''VALUE'','''||l_last_update_date||''','||l_last_updated_by||','''||l_creation_date||''','||l_created_by||',rqtab.* FROM table(rqTableEval(cursor(SELECT * FROM '||p_data_view||'),cursor(SELECT 1 as "ore.connect" FROM dual),'' select cast(''''a'''' as VARCHAR2(4000)) "RULES",1 "SUPPORT", 1 "CONFIDENCE", 1 "LIFT" from dual'','''||l_mining_function||''')) rqtab';

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.