Summary

In this chapter, you learned

• How to add rows using the INSERT statement.

• How to modify rows using the UPDATE statement.

• How to remove rows using the DELETE statement.

• How the database maintains referential integrity through the enforcement of constraints.

• How to use the DEFAULT keyword to specify default values for columns .

• How to merge rows using the MERGE statement.

• That a database transaction is a group of SQL statements that comprise a logical unit of work.

• That an Oracle database can handle multiple transactions that are performed concurrently.

In the next chapter, you ll learn about database security.