解决问题R调用sql时无法使用sql关键字

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!