From the course: Oracle Database 12c: Basic SQL
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Introduction to transactions - Oracle Database Tutorial
From the course: Oracle Database 12c: Basic SQL
Introduction to transactions
- [Instructor] In our previous video, we saw how we can use the Oracle commit and rollback commands to control the end state of transactions. Either make the changes persistent, using commit, or rollback the changes, undo the changes, using the rollback command. As we've mentioned, commit and rollback control the end states of transactions. Let's explore transactions in greater details. A transaction is an autonomous unit of work in Oracle, where data is modified. For example, when you run insert, update, or delete commands, that is, DML commands, you run them inside a transaction. When you connect to the Oracle database, and run your first DML command, a transaction will be implicitly created, and the transaction will be closed when you either issue a commit, or rollback, command. So for example, typing: insert into test_table1 values ('hello',1) and running this insert command will essentially open a new transaction in the database. Any subsequent insert commands that we will issue,…
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.
Contents
-
-
-
-
-
-
-
-
-
Introduction to DML and DDL commands2m 7s
-
Creating a simple table2m 1s
-
Inserting a new row to a table3m 15s
-
COMMIT and ROLLBACK2m 23s
-
Introduction to transactions3m 43s
-
Deleting rows for a table3m 23s
-
Updating values2m 40s
-
Multiple-statement transactions2m 41s
-
Truncating all data from a table2m 29s
-
Adding and dropping columns from a table3m 4s
-
-
-
-