Neoview SQL Reference Manual (R2.4 SP2)

Materialized Views.............................................................................................................................268
Types of Materialized Views..........................................................................................................268
MVGROUPs .......................................................................................................................................269
Null......................................................................................................................................................270
Using Null Versus Default Values.................................................................................................270
Defining Columns That Allow or Prohibit Null............................................................................270
Partitions.............................................................................................................................................272
Hash Partition Keys.......................................................................................................................272
Automatically Creating Partitions.................................................................................................272
Predicates............................................................................................................................................273
BETWEEN Predicate......................................................................................................................273
Comparison Predicates..................................................................................................................274
EXISTS Predicate............................................................................................................................278
IN Predicate...................................................................................................................................279
LIKE Predicate...............................................................................................................................281
NULL Predicate.............................................................................................................................283
Quantified Comparison Predicates...............................................................................................284
Privileges.............................................................................................................................................288
Considerations...............................................................................................................................288
Schemas...............................................................................................................................................291
Search Condition.................................................................................................................................292
Considerations for Search Condition............................................................................................292
Examples of Search Condition.......................................................................................................293
Subquery.............................................................................................................................................294
SELECT Form of a Subquery.........................................................................................................294
Using Subqueries to Provide Comparison Values.........................................................................294
Nested Subqueries When Providing Comparison Values.............................................................294
Correlated Subqueries When Providing Comparison Values.......................................................294
Synonyms............................................................................................................................................296
Tables...................................................................................................................................................297
Base Tables and Views...................................................................................................................297
Example of a Base Table.................................................................................................................297
Triggers................................................................................................................................................298
Views...................................................................................................................................................299
SQL Views......................................................................................................................................299
Example of a View.........................................................................................................................299
5 SQL Clauses...............................................................................................................301
DEFAULT Clause................................................................................................................................302
Examples of DEFAULT..................................................................................................................303
FORMAT Clause.................................................................................................................................304
Considerations for Date Formats...................................................................................................305
Considerations for Other Formats.................................................................................................305
Examples of FORMAT...................................................................................................................305
SAMPLE Clause..................................................................................................................................306
Considerations for SAMPLE..........................................................................................................307
Examples of SAMPLE....................................................................................................................308
SEQUENCE BY Clause.......................................................................................................................314
Considerations for SEQUENCE BY...............................................................................................314
Examples of SEQUENCE BY.........................................................................................................315
TRANSPOSE Clause...........................................................................................................................317
Considerations for TRANSPOSE...................................................................................................318
Examples of TRANSPOSE.............................................................................................................319
Table of Contents 9