ORA-01741: illegal zero-length identifier

sql oracle ksh
Purple picture Purple · Aug 16, 2014 · Viewed 90.4k times · Source

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

Answer

Gordon Linoff picture Gordon Linoff · Aug 16, 2014

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.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2's name and desc using …

Read More