Order By Clause

You can organize the data retrieved in any order using the Order Table Instance by feature.

You can specify an ascending or descending order for the Column's values. By default, the system displays records by sorting the values from the Column with an order number of 1 in ascending alphabetical or numerical order, depending on the Column's data type:

To order a Table instance:

1. Select a Column from the drop-down list in the Column field. Columns are listed according to their position in ascending order. Once selected, a Column does not appear in the list.
2. Select either Ascending or Descending from the drop-down condition list. Data is sorted in ascending order by default.
3. Select Apply.

You can add more Columns to order and view by using the choice list in the Add Another section, and selecting the Add button.

Use the Remove button to remove a column from the Table instance display.

For example, for a Demography table with Columns Age, Race, and Sex:

• To sort data by Age, select:

  Column—Age

• To sort data by Race,  select:

  Column—Race

• To sort data in descending order of Age, and then ascending order of Sex, select:

  Column—Age, Condition—Descending. Add another column and select:

  Column —Sex

  Tip:

  You can find more information on SQL in these books:

  You can find more information on SQL in these books:

  Oracle® DatabaseSQL Language Reference at https://docs.oracle.com/cd/E11882_01/server.112/e41084/toc.htm

  Oracle® Database PL/SQL Language Reference at https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/toc.htm

  Oracle® Database Reference at https://docs.oracle.com/cd/E11882_01/server.112/e40402/toc.htm