sql - ORA-01741: illegal zero-length identifier

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

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
                Are you sure this error is being caused by this statement? It looks perfectly fine, and this SQLFiddle shows the same. There has got to be something more going on here...
– Mureinik
                Aug 16, 2014 at 8:35
  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.
                If it helps other people, I got this error when copying a big SQL query that had been pasted into Excel - it doubled my "s up in a column name (SELECT blah AS ""Blah/Blah"" FROM Table). Thanks for the answer - it helped. :)
– FrostbiteXIII
                Jun 1, 2015 at 8:57