Download UniVerse SQL User Guide

Transcript
3Administering UniData on Windows NT or Windows 2000
0
Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta Beta
Chapter
Selecting on Multivalued
Columns
Uses for Multivalued Columns . . . . .
Associations . . . . . . . . . . .
Multivalued Columns in the Sample Database
Selection Criteria and Multivalued Columns .
Using WHERE . . . . . . . . .
Using WHEN . . . . . . . . .
Using UNNEST . . . . . . . .
Using Set Functions . . . . . . . . .
Subqueries on Nested Tables . . . . . .
Using Dynamic Normalization . . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C:\Program Files\Adobe\FrameMaker7.0\UniVerse 10.2\sqluser\Ch4TOC.fm
September 25, 2006 3:33 pm Administering UniData on Windows NT or Windows 2000
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
. .
. .
. .
. .
. .
. .
. .
. .
. .
. .
4
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
4-3
4-4
4-5
4-6
4-9
4-11
4-14
4-19
4-22
4-24