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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial