Data Control Language (DCL)
Data Control Language (DCL) is the ability to guarantee an all-or-nothing approach when changing data in more than one table. Table D-4 covers the key commands involved in DCL to manage transactions.
A good programming practice is to set a SAVEPOINT statement before beginning a set of DML statements to change related data. Then, if you encounter a failure in one of the DML statements, you can use the ROLLBACK statement to undo the DML statements that completed. You use the COMMIT command to make the changes permanent when all changes have been made successfully.
Get Oracle Database Ajax & PHP Web Application Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
