Question

Write the SQL command to change the size of the attribute BASICSAL in the table EMPLOYEES to allow the maximum value of 99999.99 to be stored in it.

Answer 1

ALTER TABLE EMPLOYEES MODIFY BASICSAL DOUBLE(8,2);