PL/SQL COMMIT Guide: Save Changes

After modifying the data in PL/SQL, you need to use the COMMIT statement to commit the changes. This operation will permanently save the modified data to the database and release the locked resources, allowing other users to access this data. An example is shown below:

-- 在 PL/SQL 中修改数据
UPDATE table_name
SET column1 = value1
WHERE condition;

-- 提交更改
COMMIT;

Before using the COMMIT statement, make sure all data modification operations are completed, as changes that have been committed cannot be rolled back. If you wish to undo changes that have already been submitted, you can use the ROLLBACK statement.