how to insert .csv data in oracle table

Question

here we can read the data with the read.csv function in R

 > mydata = read.csv("mydata.csv")  
 > mydata                           
    Col1 Col2 Col3 
 1  100   a1   b1 
 2  200   a2   b2 
 3  300   a3   b3

but my problem is how to insert .csv data in oracle table using R programing.any one can me suggest me

DCookie · Accepted Answer · 2013-11-16 18:26:04Z

1

Why do that? Use External Tables. You can then use SQL to manipulate the csv data.

EDIT:

answered Nov 16, 2013 at 6:02

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

any one example for explanation i am new in r programing