Informix Guide to SQL: Tutorial
Chapter 12: Accessing Complex Data Types
Home
Contents
Index
Master Index
New Book
Summary
This chapter introduced sample syntax and results for querying and modifying complex objects. The sections on row-type data showed how to perform the following actions:
Select columns of a typed table
Use an alias for a typed table in a
SELECT
or
UPDATE
statement
Select fields from columns that contain row type data
Select nested fields from columns that contain row type data
Insert, update, and delete fields from columns that contain named row type data
Insert, update, and delete fields from columns that contain unnamed row type data
The sections on collection-type data showed how to perform the following actions:
Select elements from columns that are collection types
Select elements from nested collections
Use the
IN
keyword to search for elements in a collection
Use the
CARDINALITY()
function to determine the number of elements in a collection
Insert, update, and delete rows that contain collection types
The sections on accessing rows from tables in a table hierarchy showed how to perform the following actions:
Select rows from a supertable
Use an alias for a supertable in a
SELECT
or
UPDATE
statement
Insert, update, and delete rows of a supertable
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.