Results 1 to 4 of 4

Thread: ALTER TABLE Statement returning an error

  1. #1
    Join Date
    Aug 2014
    Posts
    3

    ALTER TABLE Statement returning an error

    I've checked and double checked the syntax, but it seems the ALTER TABLE statement keeps returning an error.

    ALTER TABLE emp_pes605
    ADD salary number(6);

    Error occured. Recheck your SQL statement

    Also, when I try to insert data into the table, it adds two records instead of only one.

    Any help would be appreciated.

  2. #2
    Join Date
    Aug 2014
    Posts
    3
    I also just tried to update a record. It said the command was executed successfully, but the field is still blank.

  3. #3
    Join Date
    Aug 2014
    Posts
    3
    Please disregard. I found another resource for advancing my SQL skills.

  4. #4
    Join Date
    Aug 2014
    Posts
    1
    Mind sharing what you found?

Posting Permissions

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