Oracle: COMMIT statement

Commit Statement in Oracle helps to save changes done into the database. It is a good practice to follow COMMIT after DML commands because the changes done in the database will not be dropped if the session is disconnected. For DDL commands, we have an auto COMMIT feature.




We have to Alter the statement and add a column House into Stu table:

we want this change to be saved into the database, i.e. anybody who is accessing the table would be able to see the changes. For that we can apply COMMIT statement: