O'Reilly logo

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition by Bob Bryla, Roopesh Ramklass, John Watson

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

Images

CHAPTER 7

Retrieving, Restricting, and Sorting Data Using SQL

Exam Objectives

In this chapter, you will learn to

• 061.1.1    Explain the Capabilities of SQL SELECT Statements

• 061.1.2    Execute a Basic SELECT Statement

• 061.2.1    Limit the Rows Retrieved by a Query

• 061.2.2    Sort the Rows Retrieved by a Query

• 061.2.3    Use Ampersand Substitution to Restrict and Sort Output at Runtime

This chapter discusses the relational paradigm, normalizing data into relational structures, and retrieving data stored in relational tables using the SELECT statement. The statement is introduced in its basic form and is progressively built on to extend ...

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