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);
-
1Looks like you could use a semicolon after the create table statement.AndyDan– AndyDan2019-12-19 21:01:17 +00:00Commented Dec 19, 2019 at 21:01
-
Does this answer your question? Best way to do multi-row insert in Oracle?thatjeffsmith– thatjeffsmith2019-12-19 22:22:20 +00:00Commented Dec 19, 2019 at 22:22
Add a comment
|
1 Answer
Wrong syntax.
Either
insert into employee (employee_id, last_name, salary)
values (129, 'khaj', 19000);
insert into employee (employee_id, last_name, salary)
values (130, 'ravi', 20000);
or
insert into employee (employee_id, last_name, salary)
select 129, 'khaj', 19000 from dual union all
select 130, 'ravi', 20000 from dual;
or even
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;
