Scribd
Upload
13 views1 page

Understanding DML Operations in SQL

Uploaded by

Nasiruddin Sirak Shaik
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views1 page

Understanding DML Operations in SQL

Uploaded by

Nasiruddin Sirak Shaik
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

DML Operations

Data manipulation language (DML) statements add, change, and delete


table data. A transaction is a set of one or more SQL statements that Oracle
Database treats as a single unit: either all of the statements are performed, or
none of them are.

 Data manipulation language (DML) statements access and


manipulate data in existing tables.

A transaction is a sequence of one or more SQL statements that Oracle


Database treats as a unit: either all of the statements are performed, or none of
them are. You need transactions to model business processes that require that
several operations be performed as a unit.
 Committing a transaction makes its changes permanent, erases its
savepoints, and releases its locks.

 Rolling back a transaction undoes its changes. You can roll back the entire
current transaction, or you can roll it back only to a specified savepoint.

 The SAVEPOINT statement marks a savepoint in a transaction—a point to


which you can later roll back. Savepoints are optional, and a transaction
can have multiple savepoints.

Common questions

Powered by AI

Committing a transaction makes all changes made by DML statements permanent, erases savepoints, and releases any locks held during the transaction . Rolling back a transaction, on the other hand, undoes all changes made in the transaction or up to a certain savepoint, preserving data before those changes .

Transactions in DML operations ensure that a set of SQL statements are executed as a single unit, meaning they either all execute successfully or none do, maintaining data integrity . Savepoints are important because they allow partial rollbacks within a transaction, providing more control and flexibility by marking specific points to which a transaction can be undone .

You might also like