Oracle Database 10g SQL > Creating Tables, Sequences, Indexes, and Views

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Chapter 10. Creating Tables, Sequences, Indexes, and Views

In this chapter, you will

Learn more about tables
See how to create and use sequences; a sequence generates a series of numbers
Explore how to create and use indexes; an index can improve the performance of queries
Learn how to create and use views, which are predefined queries on one or more tables; among other benefits, views allow you to hide complexity from a user, and implement another layer of security by only allowing a view to access a limited set of data in the tables

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.