Informix Guide to SQL: Tutorial
Chapter 12: Accessing Complex Data Types
Home
Contents
Index
Master Index
New Book
Accessing Complex Data Types
Accessing Row-Type Data
Selecting Columns of a Typed Table
Using an Alias for a Typed Table
Selecting Columns That Contain Row-Type Data
Field Projections
Selecting Nested Fields
Modifying Rows from Typed Tables
Modifying Columns That Contain Row Type Data
Inserting Rows That Contain Named Row Types
Inserting Rows That Contain Unnamed Row Types
Updating Rows That Contain Named Row Types
Updating Rows That Contain Unnamed Row Types
Deleting Rows That Contain Row Types
Accessing Collection Type Data
Selecting Collections
Selecting Nested Collections
Using the IN Keyword to Search for Elements in a Collection
Using the CARDINALITY() Function to Count the Elements in a Collection
Modifying Collections
Inserting Rows That Contain Collection Types
Updating Collection Types
Deleting Rows That Contain Collection Types
Accessing Rows from Tables in a Table Hierarchy
Selecting Rows from a Supertable
Using an Alias for a Supertable
Inserting Rows into a Supertable
Updating Rows from a Supertable
Deleting Rows from a Supertable
Summary
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
