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.