![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle错误笔记
记录平时练习时遇到的Oracle错误及解决办法
逆火重生
这个作者很懒,什么都没留下…
展开
-
Oracle:ORA-00923: FROM keyword not found where expected错误
1.[SQL]SELECT SNO,SNAME,SCLASS WHERE STUDENT运行错误:[Err] ORA-00923: FROM keyword not found where expected错误原因:出现此错误是因为查询代码中有单词用错了1.在我的表中误把sno写成了son2.查询语句是from,我写成了where...原创 2019-11-08 16:12:57 · 2588 阅读 · 0 评论 -
Oracle:[Err] ORA-00904: "DID": invalid identifier错误
[SQL]SELECT DID AS 商品号,GNAME AS 商品名称,PRICE*STOCKQT AS 商品总值FROM GOODS错误原因:[Err] ORA-00904: “DID”: invalid identifier错误原因:表中没有DID这个属性或者变量写错了...原创 2019-11-08 16:15:01 · 411 阅读 · 0 评论