O'Reilly logo

SQL Fundamentals, Third Edition by John J. Patrick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required