O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

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

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

image 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 ...

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