Ora-01741: Illegal Zero-Length Identifier
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...
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
1 Answer
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.
Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.
