Chapter 7. Creating Schema Objects
ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Creating Other Schema Objects
Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
An Oracle database can contain far more objects than simply tables. Chapter 6, "Creating Tables and Constraints," gave you an overview of all the major objects that can be in an Oracle schema. In this chapter, you will learn in detail some of the schema objects, concentrating of course on the OCP certification exam objectives. You will be learning about creating ...
Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
