Datasheet

Chapter

Introducing SQL

ORACLE DATABASE 11g:

SQL FUNDAMENTALS I EXAM OBJECTIVES

COVERED IN THIS CHAPTER:

Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements



Execute a basic SELECT statement



Restricting and Sorting Data

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



runtime

95127c01.indd 3 2/18/09 6:37:06 AM