Summary

This chapter introduced sample syntax and results for selecting data from complex types using SELECT statements to query a relational database. The section Selecting Row-Type Data shows how to perform the following actions:

• Select row-type data from typed tables and columns
• Use row-type expressions for field projections

The section Selecting from a Collection shows how to perform the following actions:

• Query columns that are defined on collection types
• Search for elements in a collection
• Query columns that are defined on nested collection types

The section Selecting Rows Within a Table Hierarchy shows how to perform the following actions:

• Query a supertable with or without the ONLY keyword
• Specify an alias for a supertable