ORA-00920:插入时无效的关系操作符

Question

继续得到ORA-00920:无效的关系运算符在第17行(es2)。EMNEKODE LIKE 'STAT360').

但是我不明白为什么数据库突然不接受LiKE操作符了。:

有什么建议吗?

 INSERT INTO database.EMNE_I_STUDIEPROGRAM es
(
    STUDIEPROGRAMKODE,
    INSTITUSJONSNR,
    EMNEKODE,
    VERSJONSKODE,
    STATUS_RAPPORTERING,
    STATUS_PUBLISERES,
    STATUS_KREV_EMNEVALG
)
(
    SELECT es2.STUDIEPROGRAMKODE, 
           es2.INSTITUSJONSNR,
           'STAT340',
           '1',
           es2.STATUS_RAPPORTERING,
           es2.STATUS_PUBLISERES,
           es2.STATUS_KREV_EMNEVALG
    FROM database.EMNE_I_STUDIEPROGRAM es2
    WHERE es2.EMNEKODE LIKE 'STAT360'
      and es2.VERSJONSKODE LIKE '1'
      and es2.STUDIEPROGRAMKODE NOT IN (
            SELECT es3.STUDIEPROGRAMKODE
            FROM
                database.EMNE_I_STUDIEPROGRAM es3
            WHERE
                es3.EMNEKODE LIKE 'STAT340'
                and es3.VERSJONSKODE LIKE '1'
          )
);

Answer 1

如果您从问题中复制代码并运行它仍然会出错吗?(可能在你的真实代码中有一个狡猾的角色，在问题中被转换成一些正常的东西)。Alex Poole 3 hours ago