ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
来源：互联网 发布：飞行仿真软件 编辑：程序博客网 时间：2024/05/29 14:24
ORA-00932: inconsistent datatypes: expected NUMBER got CHAR:
获取的目标类型与源类型不一致，多出现在case when 语句中，when的结果类型与源类型不一致的情况，如：
case u.user_type_id when '1' then '经理' else '普通职员'
此时，user_type_id是number类型的，就会报此错误，将when后的 ‘1’ 改成 1 即可
1 0
- ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-00932: inconsistent datatypes: expected - got CLOB
- ORA-01704: string literal too long 和 ORA-00932: inconsistent datatypes: expected NUMBER got LONG
- java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
- ORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL DAY TO SECON
- inconsistent datatypes: expected DATE got NUMBER
- ORA-00932: inconsistent datatypes: expected
- ORA-00932: inconsistent datatypes
- ORA-00932: 数据类型不一致: 应为 CHAR, 但却获得 NUMBER
- Error: expected expression, got '}'
- 问题：expected expression, got ')'
- expected "indent" got "eos"
- Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got
- Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
- 1318:Incorrect number of arguments for PROCEDURE worker.wage_alterdata; expected 7, got 6 [ SQL语句 ]
- java.lang.IllegalArgumentException: Wrong number of arguments; expected 0, got 1
- IntelliJ IDEA 14的Liscense Key
- Missing Number
- 分割字符串
- c++11 mutex ，lock 和 condition_variable 的使用用简介
- leetcode-263-Ugly Number
- ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
- Web开发工具之HBuilder初探
- 大型网站架构提速关键技术
- 【JavaScript】DOM节点常用方法介绍01
- linux下 安装apache ，php等问题
- 友元运算符重载
- 【基础练习】【BFS+A*】codevs1225八数码难题题解
- 单例
- poj2031-Building a Space Station（最小生成树，kruskal，prime）
