Lesson 5 help, please!

[dustrocks]

Help! It wants me to insert multiple rows into a table I created. I can insert 1 just fine but get an error on 2 or more. Here's the code - what am I doing wrong? (Lesson is at http://sqlcourse.com/insert.html):

create table employee_rr
(first varchar(15),
last varchar(20),
title varchar(25),
age number(3),
salary number(6,2));

insert into employee_rr
(first, last, title, age, salary)
values
('Jonie', 'Weber', 'Square Dancer', 28, 19500.00),
('Potsy', 'Wiper', 'Peeping Tom', 32, 45300.00);

[rmiao]

Which rdbms do you use? Try this:

insert into employee_rr
(first, last, title, age, salary)
values
('Jonie', 'Weber', 'Square Dancer', 28, 19500.00):

insert into employee_rr
(first, last, title, age, salary)
values
('Potsy', 'Wiper', 'Peeping Tom', 32, 45300.00);