In this chapter, we've added the power of DML to our SQL abilities. We learned to add, modify, and remove data from relational tables using INSERT
, UPDATE
, and DELETE
. We've learned the importance of adding limiting conditions to our UPDATE
and DELETE
statements. We've learned about the concept of transactions and used COMMIT
, ROLLBACK
, and SAVEPOINT
to achieve transaction control. Lastly, we've looked at the types of error messages generated by Oracle.
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
At this point in the book, we've learned the basics of retrieving and manipulating data with SQL statements. However, up to now, everything we've seen has focused on statements that work with a single table. In examples where we used SELECT
, we did so only with a single table. In the next chapter, we begin to broaden our abilities. We'll learn how to take data...