SQL Error: ORA-00947

insert INTO EVERGREEN(name,salary,grade) values('Colin',6000);

Error report -

SQL Error: ORA-00947: not enough values

00947. 00000 -  "not enough values"

*Cause:    

*Action:

SOLUTION

insert INTO EVERGREEN(name,salary) values('Colin',6000);

1 rows inserted.