Oracle SQL Developer错误 [英] Oracle SQL Developer Error
问题描述
简单的sql语句:
SELECT * FROM DATACATEGORY其中ImagePath ='Images \ DataCategory \ Icons\Bus \'
返回给我几个MS Access中的记录。但是在Oracle SQL Developer中,它显示:
执行请求的操作时出现了错误:ORA-00904:IMAGEPATH:无效的标识符00904,00000 - %s无效标识符。
如果我运行
SELECT * FROM DATACATEGORY,其中ID ='2'
在Oracle SQL Developer中就可以了。
Oracle SQL语句中有什么问题?谢谢。
The simple sql statement:
SELECT * FROM DATACATEGORY where ImagePath = 'Images\DataCategory\Icons\Bus\'
returns me a couple of records in MS Access. But in Oracle SQL Developer, it shows:
An error was encounted performing the requested operation: ORA-00904: "IMAGEPATH": Invalid identifier 00904, 00000 - "%s invalid identifier".
If I run
SELECT * FROM DATACATEGORY where ID='2'
it is OK in Oracle SQL Developer.
What's wrong here in the Oracle SQL statement? Thanks.
推荐答案
在Oracle SQL Developer中以这种方式测试:
SELECT * FROM tbl_datacategory其中ImagePath='Images \ DataCategory \ Icons\Bus \'
即为字段名称添加,然后就可以了。感谢您的评论。
Tested in this way in Oracle SQL Developer:
SELECT * FROM tbl_datacategory where "ImagePath" = 'Images\DataCategory\Icons\Bus\'
namely added " " for the field name, then it works. Thanks for your review.
这篇关于Oracle SQL Developer错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!