将多行插入表中 - 出现错误 ORA-00933:SQL 命令未正确结束 [英] Inserting multiple rows into table - getting error ORA-00933: SQL command not properly ended
本文介绍了将多行插入表中 - 出现错误 ORA-00933:SQL 命令未正确结束的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
create table employee (
employee_id number (5),
first_name varchar2(100),
last_name varchar2(100),
salary number (10),
department_id number(5),
hire_date date,
constraint pk_emp primary key (employee_id)
)
insert into employee (employee_id, last_name, salary )
values
(129, 'khaj', 19000),
(130, 'ravi', 20000);
推荐答案
语法错误.
要么
insert into employee (employee_id, last_name, salary)
values (129, 'khaj', 19000);
insert into employee (employee_id, last_name, salary)
values (130, 'ravi', 20000);
或
insert into employee (employee_id, last_name, salary)
select 129, 'khaj', 19000 from dual union all
select 130, 'ravi', 20000 from dual;
甚至
insert all
into employee (employee_id, last_name, salary) values (129, 'khaj', 19000)
into employee (employee_id, last_name, salary) values (130, 'ravi', 20000)
select * from dual;
这篇关于将多行插入表中 - 出现错误 ORA-00933:SQL 命令未正确结束的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文