oracle语句报错 * ERROR at line 2: ORA-00923: FROM keyword not found where expected

时间:2024-04-07 17:25:18

报错信息:

            *

ERROR at line 2:
ORA-00923: FROM keyword not found where expected


运行语句1一直报这个错误,运行语句2成功

oracle语句报错 * ERROR at line 2: ORA-00923: FROM keyword not found where expected


用编辑器打开才发现语句1case后是tab键,语句2case后是空格键,tab键导致sql语句在执行时casewhen是连接在一起的,用记事本看了半天。。。。

oracle语句报错 * ERROR at line 2: ORA-00923: FROM keyword not found where expected