Chapter 7. Formats, Sequences, and Indexes

You now know how to build your own tables and put data in them. This chapter discusses some other features you may want to add to your tables.

Formats affect the appearance of the data without changing its value. In Access, formats can be part of the definition of a table. In Oracle, they are used mostly within SQL statements to format dates.

Sequences provide a way to automatically number the rows of a table.

Indexes are used mostly to speed up the processing of select statements within large databases.

This chapter also discusses the Data Dictionary, which shows you how to find information about the tables you create.

Get SQL Fundamentals, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.