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.