Neoview SQL Reference Manual (R2.4)

Example of ABS.............................................................................................................................324
ACOS Function...................................................................................................................................325
Examples of ACOS........................................................................................................................325
ADD_MONTHS Function...................................................................................................................326
Examples of ADD_MONTHS........................................................................................................326
ASCII Function....................................................................................................................................327
Considerations for ASCII...............................................................................................................327
Example of ASCII..........................................................................................................................327
ASIN Function.....................................................................................................................................328
Examples of ASIN..........................................................................................................................328
ATAN Function...................................................................................................................................329
Examples of ATAN........................................................................................................................329
ATAN2 Function.................................................................................................................................330
Example of ATAN2........................................................................................................................330
AVG Function......................................................................................................................................331
Considerations for AVG.................................................................................................................331
Examples of AVG...........................................................................................................................331
BITAND Function...............................................................................................................................333
Usage..............................................................................................................................................333
Restrictions.....................................................................................................................................333
Examples........................................................................................................................................333
CASE (Conditional) Expression..........................................................................................................334
Considerations for CASE...............................................................................................................335
Examples of CASE.........................................................................................................................335
CAST Expression.................................................................................................................................337
Considerations for CAST...............................................................................................................337
Valid Conversions for CAST .........................................................................................................337
Examples of CAST.........................................................................................................................337
CEILING Function..............................................................................................................................339
Example of CEILING.....................................................................................................................339
CHAR Function...................................................................................................................................340
Considerations...............................................................................................................................340
Example of CHAR.........................................................................................................................340
CHAR_LENGTH Function.................................................................................................................341
Considerations for CHAR_LENGTH............................................................................................341
Examples of CHAR_LENGTH......................................................................................................341
COALESCE Function..........................................................................................................................342
Example of COALESCE.................................................................................................................342
CODE_VALUE Function.....................................................................................................................343
Example of CODE_VALUE Function............................................................................................343
CONCAT Function..............................................................................................................................344
Concatenation Operator (||).........................................................................................................344
Considerations for CONCAT.........................................................................................................344
Examples of CONCAT...................................................................................................................344
CONVERTTOHEX Function...............................................................................................................345
Considerations for CONVERTTOHEX..........................................................................................345
Examples of CONVERTTOHEX....................................................................................................345
CONVERTTIMESTAMP Function......................................................................................................347
Considerations for CONVERTTIMESTAMP.................................................................................347
Examples of CONVERTTIMESTAMP...........................................................................................347
COS Function......................................................................................................................................348
Example of COS.............................................................................................................................348
COSH Function...................................................................................................................................349
Example of COSH..........................................................................................................................349
COUNT Function................................................................................................................................350
10 Table of Contents