Oracle SQL Developer错误
简单的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.