写作业遇到几个问题,不知如何解决。请高手指教
1.代码如下:SELECT Researcher1.Name
FROM Researcher, EditedBy, EditedBy AS EditedBy1, Researcher AS Researcher1
WHERE Researcher.Name = 'Sanjay Gupta' AND
Researcher.rID = EditedBy.rID AND
EditedBy.ISBN = EditedBy1.ISBN AND
EditedBy1.rID = Researcher1.rID;我在access中执行过,可以得到答案。但在oracle中出现错误,
FROM Researcher, EditedBy, EditedBy AS EditedBy1, Researcher AS Researcher1
*
ERROR at line 3:
ORA-00933: SQL command not properly ended我就不明白了,应该可以重命名吧。难道不行?2.代码如下:
SELECT Title
FROM Article
WHERE (Article.Title LIKE '*identity based*');我在access中试过,可以得到正确答案,在oracle中显示no rows selected。不解!
之前我写(Article.Title LIKE '%identity based%'),在access和oracle中都得不到答案,为空。我看书上写% stands for 0 or more characters先谢过~ 新手飘过
1.代码如下:SELECT Researcher1.Name
FROM Researcher, EditedBy, EditedBy AS EditedBy1, Researcher AS Researcher1
WHERE Researcher.Name = 'Sanjay Gupta' AND
Researcher.rID = EditedBy.rID AND
EditedBy.ISBN = EditedBy1.ISBN AND
EditedBy1.rID = Researcher1.rID;我在access中执行过,可以得到答案。但在oracle中出现错误,
FROM Researcher, EditedBy, EditedBy AS EditedBy1, Researcher AS Researcher1
*
ERROR at line 3:
ORA-00933: SQL command not properly ended我就不明白了,应该可以重命名吧。难道不行?2.代码如下:
SELECT Title
FROM Article
WHERE (Article.Title LIKE '*identity based*');我在access中试过,可以得到正确答案,在oracle中显示no rows selected。不解!
之前我写(Article.Title LIKE '%identity based%'),在access和oracle中都得不到答案,为空。我看书上写% stands for 0 or more characters先谢过~ 新手飘过
解决方案 »
- Oracle 10g + Windows 2008 + 8G RAM如何优化?
- js的问题大家帮帮忙
- 关于oracle查询日期横向显示的问题
- 数据库挂掉,大家可参考!不相信者可以试试。
- 100分求助:字段名字超过30个字符了,怎么改变字段名的长度???
- 请问为什么要给表加索引?
- 一个很菜的问题,谁帮我一下, 在线等待!
- oracle8和oracle8i有什么区别,这个i代表什么(初学者)???
- 我在保存一个表的数据时,有时无法保存,系统提示'ora-01041内部错误,hostdef扩展名不存在‘,这是为什么?
- 求助,oracle函数 regexp_instr('admin','\badmin\b')
- 如何计算某值在表中出现几次?
- declare 定义问题
SELECT Researcher1.Name
FROM Researcher, EditedBy, EditedBy AS EditedBy1, Researcher AS Researcher1WHERE Researcher.Name = 'Sanjay Gupta' AND
Researcher.rID = EditedBy.rID AND
EditedBy.ISBN = EditedBy1.ISBN AND
EditedBy1.rID = Researcher1.rID;
表别名不能使用AS ,直接把别名跟在后面就可以了,去掉AS 如下:
EditedBy EditedBy1, Researcher Researcher1
2
SELECT Title
FROM Article
WHERE (Article.Title LIKE '*identity based*');
改为:
WHERE (Article.Title LIKE '%identity based%');