如何将数据框(R)导出到Oracle表中

本文介绍了如何将数据框(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.