Home > database >  ORA - 01756 because the string with a semicolon line caused by the error - solution
ORA - 01756 because the string with a semicolon line caused by the error - solution

Time:09-29

Solution: the string in the semicolon [;] With such replacement: '| |'; '| |', such as the original string as' ABC;
D 'is replaced by' ABC '| |'. '| |'
D '

CodePudding user response:

 SELECT * FROM tableName WHERE ename='\; '

CodePudding user response:

Add the escape character ah \
  • Related