- A+
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')")
支付宝打赏
微信打赏
赏