Neoview SQL Reference Manual (R2.3)

Degree and Column Order of the TRANSPOSE Result...........................................................282
Data Type of the TRANSPOSE Result......................................................................................282
Cardinality of the TRANSPOSE Result....................................................................................283
Examples of TRANSPOSE.............................................................................................................283
6 SQL Functions and Expressions................................................................................289
Categories............................................................................................................................................289
Standard Normalization................................................................................................................289
Aggregate (Set) Functions..............................................................................................................289
Character String Functions............................................................................................................290
Datetime Functions........................................................................................................................291
Mathematical Functions................................................................................................................292
Sequence Functions.......................................................................................................................293
Other Functions and Expressions..................................................................................................295
ABS Function.......................................................................................................................................296
Example of ABS.............................................................................................................................296
ACOS Function...................................................................................................................................297
Examples of ACOS........................................................................................................................297
ADD_MONTHS Function...................................................................................................................298
Examples of ADD_MONTHS........................................................................................................298
ASCII Function....................................................................................................................................299
Example of ASCII..........................................................................................................................299
ASIN Function.....................................................................................................................................300
Examples of ASIN..........................................................................................................................300
ATAN Function...................................................................................................................................301
Examples of ATAN........................................................................................................................301
ATAN2 Function.................................................................................................................................302
Example of ATAN2........................................................................................................................302
AVG Function......................................................................................................................................303
Considerations for AVG.................................................................................................................303
Data Type of the Result............................................................................................................303
Operands of the Expression.....................................................................................................303
Nulls.........................................................................................................................................303
Examples of AVG...........................................................................................................................303
BITAND Function...............................................................................................................................304
Usage..............................................................................................................................................304
Restrictions.....................................................................................................................................304
Examples........................................................................................................................................304
CASE (Conditional) Expression..........................................................................................................306
Considerations for CASE...............................................................................................................307
Data Type of the CASE Expression..........................................................................................307
Character Data Type.................................................................................................................307
Numeric Data Type..................................................................................................................307
Datetime Data Type..................................................................................................................307
Interval Data Type....................................................................................................................307
Examples of CASE.........................................................................................................................307
CAST Expression.................................................................................................................................309
Considerations for CAST...............................................................................................................309
Valid Conversions for CAST .........................................................................................................309
Examples of CAST.........................................................................................................................310
CEILING Function..............................................................................................................................311
Example of CEILING.....................................................................................................................311
CHAR Function...................................................................................................................................312
Example of CHAR.........................................................................................................................312
Table of Contents 13