Results 1 to 5 of 5

Thread: Need code help please

  1. #1
    Join Date
    Feb 2014
    Posts
    2

    Need code help please

    I am just starting out and I cannot seem to find out what I have done wrong with my coding. Yes, this is novice stuff, but I cant move forward. Any help would be much appreciated.

    My coding for creating my table:

    create table hireinfo22
    (first varchar(20), last varchar(20), title varchar(20), age number(2), salary number(6,2))

    (table seems to have appeared correctly with column names)

    Then, my problem, is trying to insert in to the table.

    My coding:

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

    All that I get in response is a "." What I am doing wrong? I cant seem to figure out where the code is bad.

    Thanks!

  2. #2
    Join Date
    Feb 2014
    Posts
    2
    So I guess never mind. I jut put this code in to a different site and it worked.

  3. #3
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86

  4. #4
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    78
    insert into hireinfo22
    (first, last, title, age, salary)
    values ('Jonie', 'Weber', 'Secretary', 28, 19500.00);

    All that I get in response is a "." What I am doing wrong? I cant seem to figure out where the code is bad.
    the "." in the salary amount might have been the cause since it's the only "." .

  5. #5
    Join Date
    Feb 2014
    Location
    Riviera Beach, Maryland, USA
    Posts
    86

Posting Permissions

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