本文介绍了如何将数据框(R)导出到Oracle表中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要一些建议,如何将数据从R传输到Oracle表中.
I need a piece of advice how to transfer data from R into Oracle table.
我有一个R数据框,我想将其转移到特定的Oracle表(整个数据框或某些列)中.
I have a R-dataframe and I would like to transfer it into the specific Oracle table (the whole dataframe or some columns).
作为一种选择,通过R将放置在csv文件中的数据帧传输到Oracle.
As an option, transfer dataframe which is placed in a csv file via R into Oracle.
我已经在整个inet中扫描了类似的项目,但没有找到清晰明确的示例.
I have scanned similar items throughout the inet but not find a clear and plain examples.
推荐答案检查包 RJDBC
这里有个例子
dbWriteTable(jdbcConnection,"TABLE_NAME",data.frame.name., rownames=FALSE, overwrite = TRUE, append = FALSE)根据需要调整选项.为了覆盖TRUE,将在连接用户的架构中创建一个新表.
Adjust options as required. For overwrite TRUE a new table is created in the schema of your connection user.
更多推荐
如何将数据框(R)导出到Oracle表中
发布评论