oracle ORA-00936: missing expression 报错的几种情况和解决方法

矫情吗；* 2022-07-15 15:20 166阅读 0赞

[oracle ORA-00936: missing expression 报错的几种情况和解决方法][oracle ORA-00936_ missing expression] *2013-04-29 17:20:38*

分类： Oracle

ORA-00936: missing expression     
Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.     
Action: Check the statement syntax and specify the missing component.

我遇到的2种  ORA-00936: missing expression 报错情况  
1、插入表数据 insert into t1 values select 1 from dual;  
2、用pl/sql developer 工具比较时报错  原因：表字段是oracle关键字----也就是在查询这个带有关键字列的时候  
**测试1：**  
SQL> create table t1 ("desc" varchar2(10));

表已创建。

SQL> desc t1;  
名称                                      是否为空? 类型  
\----------------------------------------- -------- ----------------------------  
desc                                               VARCHAR2(10)

SQL> insert into t1 values select 1 from dual;  
insert into t1 values select 1 from dual  
                      \*  
第 1 行出现错误:  
ORA-00936: 缺失表达式  
SQL>解决就是把values去掉就可以了

**测试2：**  
SQL> select desc from t1;  
select desc from t1  
       \*  
第 1 行出现错误:  
ORA-00936: 缺失表达式

SQL>  
**测试2(2)：**用pl/sql developer 工具比较时的报错  
[![28602568_201305131452431.jpg][]][28602568_201305131452431.jpg 1]  
解决方法：  
ALTER TABLE T1 RENAME COLUMN "desc" TO desc\_;(比较的话目标和源库都要相同)  
再比较或者查询就没有问题了  
  
  
祝好~

阅读(38242) | 评论(0) | 转发(0) |

上一篇：[(f)--闪回恢复区-- 并行加载对闪库的影响][f_--_--]

下一篇：[ORA-01940: 无法删除当前连接的用户][ORA-01940_]

[oracle ORA-00936_ missing expression]: http://blog.itpub.net/28602568/viewspace-759513/
[28602568_201305131452431.jpg]: http://space.itpub.net/attachments/2013/05/28602568_201305131452431.jpg
[28602568_201305131452431.jpg 1]: http://space.itpub.net/batch.download.php?aid=37957
[f_--_--]: http://blog.itpub.net/28602568/viewspace-758933/
[ORA-01940_]: http://blog.itpub.net/28602568/viewspace-759514/