Neoview SQL Reference Manual (R2.4 SP2)

examples of, 419
syntax diagram of, 419
MOVINGVARIANCE function
examples of, 420
syntax diagram of, 420
MVGROUP, definition of, 269
N
NATIONAL CHAR data type, 236
NATIONAL CHAR VARYING data type, 236
NATURAL FULL join, description of, 168
NATURAL join, description of, 168
NATURAL LEFT join, description of, 168
NATURAL RIGHT join, description of, 168
NCHAR data type, 236
NCHAR VARYING data type, 236
Neoview SQL objects, logical names, 230
NOT CASESPECIFIC, 77
NOT NULL constraint, 227
NULL predicate
examples of, 284
syntax diagram of, 283
Null symbol, 270
NULL, using, 198
NULLIF function
example of, 422
syntax diagram of, 422
NULLIFZERO function
examples of, 423
syntax diagram of, 423
Numeric data types
approximate numeric, 241
exact numeric, 241
extended numeric , 234
literals, examples of, 267
Numeric literals
approximate, 266
exact, 266
examples of, 267
Numeric value expression
evaluation order, 254
examples of, 256
syntax diagram of, 253
NVL function
examples of, 424
syntax diagram of, 424
O
Object names, 230
Object namespace, 230
Object-privilege, general rules, 288
Objects
description of, 230
logical names, 230
OCTET_LENGTH function
CHAR_LENGTH similarity to, 425
examples of, 425
syntax diagram of, 425
OFFSET function
examples of, 426
syntax diagram of, 426
OLAP window functions, 479
AVG window function, 481
COUNT window function, 483
DENSE_RANK window function, 485
limitations, 480
MAX window function, 486
MIN window function, 488
ORDER BY clause, 479
RANK window function, 490
ROW_NUMBER window function, 491
STDDEV window function, 492
SUM window function, 493
VARIANCE window function, 495
Operators in query execution plan, 122
OPTIONS ’e’ on Explain statement, 122
OPTIONS ’f’ on Explain statement, 122
OPTIONS ’m’ on Explain statement, 122
OPTIONS ’n’ on Explain statement, 122
ORDER BY clause
AS and ORDER BY conflicts, 173
guidelines for CREATE VIEW, 103
Other functions and expressions
BITAND , 341
CASE expression, 342
CAST expression, 345
COALESCE, 350
CONVERTTOHEX, 354
CURRENT_ROLE, 363
CURRENT_USER, 366
DECODE, 380
EXPLAIN, 389
ISNULL, 396
NULLIF, 422
NVL, 424
USER, 472
P
Partitions
creating, 87
described, 272
Performance
and materialized views, 268
and MVGROUPs, 215
calculating row size, 87
CAST, 345
ORDER BY clause, 175
SAMPLE statement, cluster sampling, 308
updating rows, 199
PI function
examples of, 427
syntax diagram of, 427
POPULATE INDEX utility
considerations for, 218
examples of, 219
syntax diagram of, 218
POSITION function
examples of, 428
532 Index