Results 1 to 4 of 4

Thread: SQL Course Lesson 5

  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Question SQL Course Lesson 5

    Could someone help me get past lesson 5 of the first SQLCourse.com? I keep
    putting in what I feel are the right commands for inserting records, but
    keep getting an error, for weeks now.
    Here's the code I put:

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

    The table, with those fields, was successfully created previously.
    Help. Thanks.
    Vince Deegan

  2. #2
    Join Date
    Aug 2002
    Posts
    21
    vdeegan, I just tried it, and it worked, but you must go through the procedures in order...first I created the table thusly:

    create table myemployees_jvd0515(firstname varchar(30),
    lastname varchar(30),
    title varchar(30),
    age number(2),
    salary number(8,2));

    then I inserted the data:

    insert into myemployees_jvd0515
    (firstname, lastname, title, age, salary)
    values ('Jonie', 'Weber',
    'Secretary', 28, 19500.00);

    No problems at all. Try again using a different table name and you shouldn't have any problems.

  3. #3
    Join Date
    Oct 2002
    Posts
    2
    I had been creating the table before doing any inserts. I tried it again exactly like you did it, but I'm still getting the same old error message. Don't know why it doesn't work when I do it and why it works when you do it. We're apparently doing the exact same thing. Again, here's my syntax:

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

    Then,

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

    I tried it several ways:
    1) Did the create in lesson 4 and the insert in lesson 5.
    2) Did the create in the first query window of lesson 5 and the insert in the second query window of lesson 5.
    3) Did the create followed by the insert as a separate statement, both in the first query window of lesson 5.

    Nothing works. Help again. Thanks.

  4. #4
    Join Date
    Aug 2002
    Posts
    21
    I'm stumped...I just tried it again, just cutting and pasting from the thread above. I created the table, then populated it, and didn't have any problems. Are you manually typing the text in, or cutting and pasting? You may need to change the table name...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •