2 messages · Rajarshi Guha, Don MacQueen
Hi, I'm using the ROracle package and I've been looking for a way to insert data into a table at one go. While I can create multiple insert statements, I was hoping that I could supply a data.frame (wth the appropriate columns) and have a single function insert them at one go. While I could write this function myslf, I was wondering if any body has done something like this befoe. Thanks,
Rajarshi Guha [[alternative HTML version deleted]]
See the dbWriteTable function, and note the "append" argument. -Don
Hi, I'm using the ROracle package and I've been looking for a way to insert data into a table at one go. While I can create multiple insert statements, I was hoping that I could supply a data.frame (wth the appropriate columns) and have a single function insert them at one go. While I could write this function myslf, I was wondering if any body has done something like this befoe. Thanks, -- Rajarshi Guha [[alternative HTML version deleted]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://*stat.ethz.ch/mailman/listinfo/r-sig-db
-------------------------------------- Don MacQueen Environmental Protection Department Lawrence Livermore National Laboratory Livermore, CA, USA 925-423-1062