Summary

This chapter introduced sample syntax and results for selecting data from complex types using SELECT statements to query a relational database. The section Select 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 Select 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 Select 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