PDF《Session 4:》

2018 Oracle and/or its affiliates. All rights reserved. | Embedded Script Execution C SQL Interface ORE function Input data FUN.VALUE Arguments R Script Special rqEval None Generated within R function Load via ore.pull Transparency layer ROracle data load Flat file data load NULL (returns chunked blob) table signature (returns table) XML PNG NULL or Cursor with single row select statement with scalar values R script name Not applicable rqTableEval table cursor Not applicable rqRowEval Integer >=

1 "rqGroupEval" Single column name sys.rqScriptCreate Not applicable Not applicable R script name R function Not applicable sys.rqScriptDrop Not applicable R script name Not applicable Copyright ?

2018 Oracle and/or its affiliates. All rights reserved. | Passing parameters ? Directly pass scalar numeric and string values as R parameters via parameter cursor select count(*) from table(rqTableEval( cursor ( select x as "x", y as "y", parameter_value as "z" from geological_model_grid), cursor( select

30 as "levels", '/oracle/image.png' as "filename",

1 "ore.connect" from dual), NULL, 'Example5'));

? To pass non-scalar R parameter (e.g., a model or list) C use a datastore object C preferred C construct string that can be parsed inside user-defined function Copyright ?

2018 Oracle and/or its affiliates. All rights reserved. | rqEval C invoking a simple R script begin --sys.rqScriptDrop('Example1') sys.rqScriptCreate('Example1', 'function() { ID