Originally posted by blmartin
INSERT INTO SAL_HIST VALUES('LASTNAME', 'FIRSTNAME', HOURS, RATE, DEPEN, TAX,
BONUS, YEARS, NETSALARY);
Learn from this...*never* write an insert without specifying the column list.

This should be:

INSERT INTO SAL_HIST (
LASTNAME, FIRSTNAME, HOURS, RATE, DEPEN, TAX,BONUS, YEARS, NETSALARY
)
VALUES(
'LASTNAME', 'FIRSTNAME', HOURS, RATE, DEPEN, TAX,BONUS, YEARS, NETSALARY
);

- Chris