R语言连接ORCLE数据库

library(RJDBC)
drv<-JDBC("oracle.jdbc.driver.OracleDriver","ojdbc6_g.jar", identifier.quote=""")  ##java中JDBC的套路
conn<-dbConnect(drv,"jdbc:oracle:thin:@192.168.1.159:1521:ORCL","mts","mts") ##建立一个连接
EMP<-dbReadTable(conn,'GY_CHUFANGLX')
help(dbReadTable)
names(table1)=iconv(names(table1),"UTF-8","GBK")