1、直接select 表,用单引号,可以获取到数据
library(DBI)
library(ROracle)
drv=dbDriver('Oracle')
conn=dbConnect(drv,'test','test','192.111.10.01:1521/ZNJT')
rs=dbSendQuery(conn,'select * from dw_fact ')
data=fetch(rs)
2、如果给select 语句加上oracle关键字,则会报错
rs=dbSendQuery(conn,'select * from dw_fact where gcsj=to_char(sysdate,'yyyymmdd')-30000+900+8
and sd=to_char(sysdate,'hh24')')
错误:
Error: unexpected symbol in "rs=dbSendQuery(conn,'select * from dw_fact where gcsj=to_char(sysdate,'yyyymmdd"
Error: unexpected symbol in " and sd"
3、解决方法,对select语句用双引号
rs=dbSendQuery(conn,"select * from dw_fact where gcsj=to_char(sysdate,'yyyymmdd')-30000+900+8
and sd=to_char(sysdate,'hh24')")
ok!