O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Chapter 2. SQL SELECT Statements

In the previous chapter, we laid the groundwork for using SQL with Oracle databases. Now, we are almost ready to begin writing our own SQL statements. But, first, we'll need to examine the rules. Once that's complete, we will proceed to learn several different basic SQL queries, all derived from the single, most important SQL statement at our disposal—the SELECT statement. With this statement, we can retrieve data from an Oracle database and, by the end of the chapter, will begin to do transformations of the data as well. Beginning with this chapter, we also make note of the Certification objectives covered. This is a guide for us to match our subject matter with the objectives of the certification exam.

In this ...

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