This is completely for SQL Assignments. Contribute to KarthiApi/SQL_Assignments development by creating an account on GitHub.
ALTER TABLE employee ADD (exp NUMBER,salary NUMBER(8,2)); --> 2.ii ALTER TABLE table_name MODIFY col_name new_dtype; --> ALTER TABLE table_name MODIFY(col_name1 new_dtype1,col_nname2 new_dtype2); ...