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 ...
Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
