Neoview SQL Reference Manual (R2.5)

syntax diagram of, 426
MOVINGMAX function
examples of, 427
syntax diagram of, 427
MOVINGMIN function
examples of, 428
syntax diagram of, 428
MOVINGSTDDEV function
examples of, 429
syntax diagram of, 429
MOVINGSUM function
examples of, 431
syntax diagram of, 431
MOVINGVARIANCE function
examples of, 432
syntax diagram of, 432
MVGROUP, definition of, 282
N
NATIONAL CHAR data type, 248
NATIONAL CHAR VARYING data type, 249
NATURAL FULL join, description of, 169
NATURAL join, description of, 169
NATURAL LEFT join, description of, 169
NATURAL RIGHT join, description of, 169
NCHAR data type, 248
NCHAR VARYING data type, 249
Neoview SQL objects, logical names, 242
NOT CASESPECIFIC, 78
NOT NULL constraint, 237
NULL predicate
examples of, 297
syntax diagram of, 296
Null symbol, 283
NULL, using, 199
NULLIF function
example of, 434
syntax diagram of, 434
NULLIFZERO function
examples of, 435
syntax diagram of, 435
Numeric data types
approximate numeric, 253
exact numeric, 253
extended numeric , 246
literals, examples of, 280
Numeric literals
approximate, 279
exact, 279
examples of, 280
Numeric value expression
evaluation order, 266
examples of, 268
syntax diagram of, 265
NVL function
examples of, 436
syntax diagram of, 436
O
Object names, 242
Object namespace, 242
Object-privilege, general rules, 301
Objects
description of, 242
logical names, 242
OCTET_LENGTH function
CHAR_LENGTH similarity to, 437
examples of, 437
syntax diagram of, 437
OFFSET function
examples of, 438
syntax diagram of, 438
OLAP window functions, 491
AVG window function, 493
COUNT window function, 495
DENSE_RANK window function, 497
limitations, 492
MAX window function, 498
MIN window function, 500
ORDER BY clause, 491
RANK window function, 502
ROW_NUMBER window function, 503
STDDEV window function, 504
SUM window function, 505
VARIANCE window function, 507
Operators in query execution plan, 124
OPTIONS ’e’ on Explain statement, 124
OPTIONS ’f’ on Explain statement, 124
OPTIONS ’m’ on Explain statement, 124
OPTIONS ’n’ on Explain statement, 124
ORDER BY clause
AS and ORDER BY conflicts, 174
guidelines for CREATE VIEW, 104
Other functions and expressions
BITAND , 353
CASE expression, 354
CAST expression, 357
COALESCE, 362
CONVERTTOHEX, 366
CURRENT_ROLE, 375
CURRENT_USER, 378
DECODE, 392
EXPLAIN, 401
ISNULL, 408
NULLIF, 434
NVL, 436
USER, 484
P
Partitions
creating, 87
described, 285
Performance
and materialized views, 281
and MVGROUPs, 217
calculating row size, 87
CAST, 357
544 Index