以下预言机查询中有关从键盘的错误

Question

我在下面有这个查询，但是当我通过sqlplus/nolog执行时它会引发异常

SELECT 'EXEC DROP_CONSTRAINTS('TK_TYUOICE_REWOURCE','WQEA_INVOTRY');' FROM DUAL
                                                       *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

SELECT 'ALTER TABLE WQEA_INVOTRY ADD CONSTRAINT TK_TYUOICE_REWOURCE CHECK (SOURCE_SYSTEM IN ('WER','TYU'));' FROM DUAL
                                                                                                     *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

Answer 1

您需要转义字符串中的单引号。 为此，只需加倍使用它们：

SELECT 'EXEC DROP_CONSTRAINTS(''TK_TYUOICE_REWOURCE'', ''WQEA_INVOTRY'');' 
FROM DUAL