'Specifying column names' diaporamas de présentation

3.04k views • 278 slides

Restricting and Sorting Data

Restricting and Sorting Data. Ceng 356-Lab2. Objectives. After completing this lesson, you should be able to do the following: Limit the rows that are retrieved by a query Sort the rows that are retrieved by a query Use ampersand substitution to restrict and sort output at run time.

469 views • 36 slides

Producing Readable Output with SQL*Plus

Producing Readable Output with SQL*Plus. Objectives. At the end of this lesson, you should be able to: Produce queries that require an input variable Customize the SQL*Plus environment Produce more readable output Create and execute script files Save customizations. Interactive Reports.

433 views • 29 slides