ROracle需要先登陆oracle账户，刷新界面后再从下方地址下载，否则会下载失败ROracle下载地址：https://www.oracle.com/database/technologies/roracle-downloads.html ROracle依赖包：https://cran.r-project.org/web/packages/DBI/index.html …

fun <- function(){ library(ROracle) drv <- dbDriver('Oracle') host <- '172.24.111.100' # 服务器IP地址 port <- 1521 # 端口 sid <- 'MRMSDB' connect.string <- paste( "…

--创建R脚本BEGIN sys.rqScriptDrop('TEST_SCRIPT'); sys.rqScriptCreate('TEST_SCRIPT', 'function(x, param) #param这个参数是可选的 { job_date <- as.numeric(as.matrix(x)) resultOfAll <- data.frame(job_date=j…