san <- sqlQuery(echo, 'select * from ifsapp&tbwJobTip')
san
[1] "HY000 933 [Oracle][ODBC][Ora]ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø\n"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'select * from ifsapp&tbwJobTip'"
ODBC数据源已配置成功,RODBC已加载,求教,谢谢
san <- sqlQuery(echo, 'select * from ifsapp&tbwJobTip')
san
[1] "HY000 933 [Oracle][ODBC][Ora]ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø\n"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'select * from ifsapp&tbwJobTip'"
ODBC数据源已配置成功,RODBC已加载,求教,谢谢
问题已解决.
sql语句,应该用“”,不能用'',且视图的名称写错了