OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

4Retrieving Data Using the SQL SELECT Statement

CERTIFICATION OBJECTIVES

4.01 Execute a Basic SELECT Statement

4.02 List the Capabilities of SQL SELECT Statements

4.03 Describe How Schema Objects Work

Two-Minute Drill

Q&A Self Test

This chapter introduces the basic syntax of the most commonly used SQL statement, which is the SELECT statement. The SQL SELECT statement retrieves data from the database. The SELECT statement does not change the data that’s stored in the database, but it does have the ability to transform that data as it is pulled out of the database and displayed, and therein lies its power and usefulness. SELECT has the ability to ...