Stuck at lesson 5

[wolf182]

Hi, This is my first post to this forum.

I haven't done much work with DBs and just started doing the http://sqlcourse.com/ online course.

In lesson 4 you make a table.
I did that without a problem.
Here's my (masked) string

create table myemployees_jpXXX
(first varchar(30),
 last varchar(30),
 title varchar(30)
 age number(3),
 salary number(8,2));

In lesson 5 you start populating the table.

No matter what I try, I get the error:
"Error occured. Recheck your SQL statement"

Here's my 1st Insert string:

insert into myemployees_jpXXX
  (first, last, title, age, salary)
  values ('Jonie', 'Weber', 'Secretary', 28, 19500.00);

Can someone show me where the mistake is?

[wolf182]

never mind, I found it.
I was missing a comma after this line:
title varchar(30)

So the table didn't have an age column.

I'm just surprised I didn't get an error when I did the create table call.

[paige1]

I have found that if after you click "submit query", and you get a good "command executed" yet nothing shows up on the page (when it should)this means that the sql syntax is correct but something is misspelled, or there is a upper or lowercase issue.