ORA-01741:非法的零长度标识符 [英] ORA-01741: illegal zero-length identifier

问题描述

我在shell脚本中使用了删除查询，并且遇到了这个问题.

   delete from WHITELIST_CLI where filecode like'%Line_Index_condense%';

错误:

 ERROR:
 ORA-01741: illegal zero-length identifier

解决方案

以下是有关错误的一些信息:

ORA-01741:非法的零长度标识符

原因:尝试使用两个双引号(")作为 标识符.标识符必须至少一个字符长.

您的查询没有任何内容.这可能是ksh与Oracle之间的交互.或者，当您指的是单引号时，您可能已使用双引号.或者，当您发布问题时，您可能简化了查询.否则可能是另一个查询.

此处是SQL Fiddle上错误的简单示例.

Hi I am using a delete query in my shell script and I am facing this issue.

   delete from WHITELIST_CLI where filecode like'%Line_Index_condense%';

Error:

 ERROR:
 ORA-01741: illegal zero-length identifier

解决方案

Here is some information on the error:

ORA-01741: illegal zero-length identifier

Cause: An attempt was made to use two double quotes ("") as an identifier. An identifier must be at least one character long.

Your query has nothing of the sort. This may be an interaction between ksh and Oracle. Or you may have used double quotes when you mean single quotes. Or, you may have oversimplified the query when you posted the question. Or another query may be the issue.

Here is a simple example of the error on SQL Fiddle.

这篇关于ORA-01741:非法的零长度标识符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！