SQL Fundamentals, Third Edition

Chapter 5. The Data Dictionary and Other Oracle Topics

This chapter expands on the topics we discussed in chapter 4. In this chapter, we discuss transactions and modifying data through a view. We also discuss the SQL Commands page, which Oracle uses to run an SQL command. You learn how to find information about the tables and views we have created and the ones that have already been created for us.

Commit, Rollback, and Transactions		173
5-1	The commit and rollback commands	173
5-2	The Autocommit option	174
5-3	Transactions	175
Modifying Data through a View		179
5-4	Changing data through a view	180
5-5	Example of changing data through a view	181
5-6	Views using With Check Option	189
The SQL Commands Page in Oracle		192
5-7	Overview of the SQL Commands page	192
5-8	The Autocommit ...