Chapter 4. Using Joins and Subqueries

ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER

  • Displaying data from multiple tables

    • Write SELECT statements to access data from more than one table using equijoins and nonequijoins

    • Join a table to itself by using a self-join

    • View data that generally does not meet a join condition by using outer joins

    • Generate a Cartesian product of all rows from two or more tables

  • Using subqueries to solve queries

    • Define subqueries

    • Describe the types of problems that the subqueries can solve

    • List the types of subqueries

    • Write single-row and multiple-row subqueries

  • Using the Set operators

    • Describe set operators

    • Use a set operator to combine multiple queries into a single query

    • Control the order of rows returned ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.