ORA-00923: FROM keyword not found where expected(单双引号)
来源:互联网 发布:淘宝上买狗狗怎么快递 编辑:程序博客网 时间:2024/04/30 13:54
1、前言
今天学习oracle遇到一个错误,是一个关于单双引号的小问题,以前从来没在意过,记录在这里。备忘2、具体问题
表结构语句是这样:
create table demo(id int,name varchar(20),nums int); ---- 创建表
我的查询语句如下:
select sum(decode(name,'苹果',nums,0)) as '苹果', sum(decode(name,'橘子',nums,0)) as '橘子', sum(decode(name,'葡萄',nums,0)) as '葡萄', sum(decode(name,'芒果',nums,0)) as '芒果' from demo d
由于以前没注意过,但是上面的这段代码一执行就报错:ORA-00923: FROM keyword not found where expected,为什么呢?请看下面改过的代码
select sum(decode(name,'苹果',nums,0)) as "苹果", sum(decode(name,'橘子',nums,0)) as "橘子", sum(decode(name,'葡萄',nums,0)) as "葡萄", sum(decode(name,'芒果',nums,0)) as "芒果" from demo d
可以发现其实就是as后面的单双引号问题,改成双引号语句就正常执行了。也许在怀疑是不是中文的问题,于是再看下面的代码:
select sum(decode(name,'苹果',nums,0)) as 'A', sum(decode(name,'橘子',nums,0)) as 'B', sum(decode(name,'葡萄',nums,0)) as 'C', sum(decode(name,'芒果',nums,0)) as 'D' from demo d
可是还是出错的额,不知道是我的语句导致这个不能单引号还是其他的,反正要加引号就加双引号吧,要不就像下面那样就得了::
select sum(decode(name,'苹果',nums,0)) as 苹果, sum(decode(name,'橘子',nums,0)) as 橘子, sum(decode(name,'葡萄',nums,0)) as 葡萄, sum(decode(name,'芒果',nums,0)) as 芒果 from demo d
直接不加是最好的方法,不会错。只是记录一下上面问题,方便以后翻阅。。。。。
阅读全文
0 0
- ORA-00923: FROM keyword not found where expected(单双引号)
- ORA-00923: FROM keyword not found where expected
- ORA-00923: FROM keyword not found where expected
- java.sql.SQLException: ORA-00923: FROM keyword not found where expected
- Exception in thread "main" java.sql.SQLException: ORA-00923: FROM keyword not found where expected
- [Err] ORA-00923: FROM keyword not found where expected 与rownum
- oracle语句报错 * ERROR at line 2: ORA-00923: FROM keyword not found where expected
- 在用hibernate实现oracle 分页查询时报错ORA-00923: FROM keyword not found where expected
- 在用hibernate实现oracle 分页查询时报错ORA-00923: FROM keyword not found where expected
- RMAN-06059: expected archived log not found,ORA-19625
- 解决pop3:pop3(某帳號): Error syncing mbox file /var/mail/某帳號: LF not found where expected
- Bareword found where operator expected at 错误
- Springmvc UPDATE 数据时 ORA-01858:a non-numeric character was found where a numeric was expected
- django-- keyword arguments '{}' not found错误
- bash [[: not found, '[[' is a keyword not a builtin
- RMAN-06059: expected archived log not found
- RMAN-06059: expected archived log not found
- found tag Stirng where item is expected解决办法
- jquery事件对象
- Ndk学习之C语言异常(java->c)
- jquery表单事件
- jqueryDOM属性
- jqueryDOM操作
- ORA-00923: FROM keyword not found where expected(单双引号)
- jquery遍历
- 汇真科技李利鹏 :人工智能的应用边界
- jquery特效
- 互联网如何促进经济发展?腾讯、谷歌、Facebook的实践和经验
- Jeff Dean| 面向系统的机器学习和面向机器学习的系统
- 腾讯AI Lab刷新人脸检测与识别两大测评国际记录,技术日调用超六亿
- jquery幽灵按钮
- jquery瀑布流