CODEWITHSUNDEEP
oracle-databasetransactions
bbb
bbb

Reputation: 1489

Oracle: What is a transaction?

I'm new to Oracle so I'm still learning the basics. Can someone explain to me what a transaction is? When I look it up it always seems to contain an update statement but is this a necessary feature? How is it declared? How is it any different to anonymous block?

Any help in explaining this would be much appreciated!

Upvotes: 0

Views: 1526

Answers (1)

Hayes121
Hayes121

Reputation: 67

A transaction is a logical unit of work that contains one or more SQL statements. A transaction is an atomic unit. The effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

A transaction begins with the first executable SQL statement. A transaction ends when it is committed or rolled back, either explicitly with a COMMIT or ROLLBACK statement or implicitly when a DDL statement is issued.

Upvotes: 3

Related Questions