Neoview SQL Reference Manual (R2.4)

Comparison Predicates..................................................................................................................268
EXISTS Predicate............................................................................................................................272
IN Predicate...................................................................................................................................273
LIKE Predicate...............................................................................................................................275
NULL Predicate.............................................................................................................................277
Quantified Comparison Predicates...............................................................................................278
Privileges.............................................................................................................................................282
Considerations...............................................................................................................................282
Schemas...............................................................................................................................................285
Search Condition.................................................................................................................................286
Considerations for Search Condition............................................................................................286
Examples of Search Condition.......................................................................................................287
Subquery.............................................................................................................................................288
SELECT Form of a Subquery.........................................................................................................288
Using Subqueries to Provide Comparison Values.........................................................................288
Nested Subqueries When Providing Comparison Values.............................................................288
Correlated Subqueries When Providing Comparison Values.......................................................289
Synonyms............................................................................................................................................289
Tables...................................................................................................................................................290
Base Tables and Views...................................................................................................................290
Example of a Base Table.................................................................................................................290
Triggers................................................................................................................................................291
Views...................................................................................................................................................292
SQL Views......................................................................................................................................292
Example of a View.........................................................................................................................292
5 SQL Clauses...............................................................................................................293
DEFAULT Clause................................................................................................................................294
Examples of DEFAULT..................................................................................................................295
FORMAT Clause.................................................................................................................................296
Considerations for Date Formats...................................................................................................297
Considerations for Other Formats.................................................................................................297
Examples of FORMAT...................................................................................................................297
SAMPLE Clause..................................................................................................................................298
Considerations for SAMPLE..........................................................................................................299
Examples of SAMPLE....................................................................................................................300
SEQUENCE BY Clause.......................................................................................................................306
Considerations for SEQUENCE BY...............................................................................................306
Examples of SEQUENCE BY.........................................................................................................307
TRANSPOSE Clause...........................................................................................................................309
Considerations for TRANSPOSE...................................................................................................310
Examples of TRANSPOSE.............................................................................................................311
6 SQL Functions and Expressions................................................................................317
Categories............................................................................................................................................317
Standard Normalization................................................................................................................317
Aggregate (Set) Functions..............................................................................................................317
Character String Functions............................................................................................................318
Datetime Functions........................................................................................................................319
Mathematical Functions................................................................................................................320
Sequence Functions.......................................................................................................................321
Other Functions and Expressions..................................................................................................323
ABS Function.......................................................................................................................................324
Table of Contents 9