Oracle Database 10g SQL (Osborne ORACLE Press Series)

Overview

Inthis 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

Let s plunge in and examine tables.