ORA-00936 Missing expression

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/07/18 01:53:33

ORA-00936 Missing expression
sqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE
fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value
& "' AND fv.Fund_id = " & Cells(j, 4).Value
这是vba的一段,有错误,大
概意思从取fv表所有,f表的lipper_id,但要符合fv表和f表的主键fv.fund_id=f.fund_id,而且同时符合fv表的
Effective_date为cells（j,2).和Fund_id等于excel的cells（j,4)
请大侠赐教

FROM Fund_Values fv(就是这个地方你少个逗号)fund f

ORA-00936 Missing expression missing expression MISSING . missing 欧美歌手rita ora外号? ORA-01031:权限不足 expression是什么意思? ORA-01034:ORACLE not available ORA-27101:shared memory realm 借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listen Missing you,missing you,nothing but missing simplify each expression isoform expression什么意思