O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Sorting data

One of the most common uses of datasets that have been extracted in the manner we have seen in this chapter is for reporting. Reporting is one of the cornerstones for data usage in today's world, and the ability to sort data in ways that display it for a certain purpose is often crucial. Data that has been extracted by using one or more of our selection methods is useful, but the ability to sort the data adds another dimension to the usefulness of that data.

Understanding the concepts of sorting data

In Oracle, standard tables are referred to as heap-organized tables, which means that the data within them is stored in the order that it was written in. For instance, if I insert data rows into a simple table in the following order—orange, ...

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