Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Select data from complex types
Summary

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