O'Reilly logo

OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM : Exams 1Z0-051, 1Z0-052, 1Z0-053 by Bob Bryla, Roopesh Ramklass, John Watson

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 12SQL Joins

Exam Objectives

In this chapter you will learn to

• 051.6.1 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins

• 051.6.2 Join a Table to Itself Using a Self-Join

• 051.6.3 View Data That Does Not Meet a Join Condition Using Outer Joins

• 051.6.4 Generate a Cartesian Product of All Rows from Two or More Tables

The three pillars of relational theory are selection, projection, and joining. This chapter focuses on the practical implementation of joining. Rows from different tables or views are associated with each other using joins. Support for joining has implications for the way data is stored, and many data models such as third normal form or star schemas have emerged to exploit ...

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