为什么我的SQL失败? (ORA-00933:SQL命令未正确结束) [英] Why is my SQL failing? (ORA-00933: SQL command not properly ended)

问题描述

为什么我的SQL失败?我认为它的格式正确，但是却向我抛出错误.

Why is my SQL failing? I think it s formatted correctly, but it throws an error at me.

    INSERT INTO NBOT_USERS
       (ID,LAST_NAME,FIRST_NAME)
    VALUES
       (1002, 'Smith', 'John')
    WHERE 1002 NOT IN (SELECT IT_ID FROM NBOT_USERS);

推荐答案

通过子查询插入值:示例

INSERT INTO bonuses
   SELECT employee_id, salary*1.1 
   FROM employees
   WHERE commission_pct > 0.25 * salary;

使用您的架构:

INSERT INTO NBOT_USERS (ID,LAST_NAME,FIRST_NAME)
Select 1002, 'Smith', 'John' 
  From dual
  WHERE 1002 NOT IN (SELECT  FROM NBOT_USERS);

这篇关于为什么我的SQL失败? (ORA-00933:SQL命令未正确结束)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！