From the course: Learning Oracle Database 12c
Join today to access over 25,300 courses taught by industry experts.
Data manipulation language (DML): In action - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Data manipulation language (DML): In action
- [Instructor] Let's talk about database transactions, specifically, the COMMIT and ROLLBACK statements. What is a database transaction? It's a series of statements that is one of these three things. One or more DML statements that changes data in your tables, one DDL statement, or one DCL statement. Database transactions start the first time you run a DML statement and it ends when you issue a COMMIT or ROLLBACK. It's possible that your system may crash in the middle of your work and that will issue an automatic ROLLBACK for you, but primarily you will be issuing the COMMIT or ROLLBACK statement in your code. There's also a third statement called SAVEPOINT and we'll give a quick example of that later, but it helps you issue your DML statements more incrementally to make it easier to ROLLBACK only part of your transaction, if that makes sense from a business perspective. In a nutshell, COMMIT makes all pending data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.