Neoview SQL Reference Manual (R2.4)

NULL, using, 197
NULLIF function
example of, 417
syntax diagram of, 417
NULLIFZERO function
examples of, 418
syntax diagram of, 418
Numeric data types
approximate numeric, 238
exact numeric, 238
extended numeric , 232
literals, examples of, 262
Numeric literals
approximate, 261
exact, 261
examples of, 262
Numeric value expression
evaluation order, 250
examples of, 251
syntax diagram of, 250
NVL function
examples of, 419
syntax diagram of, 419
O
Object names, 228
Object namespace, 228
Object-privilege, general rules, 282
Objects
description of, 228
logical names, 228
OCTET_LENGTH function
CHAR_LENGTH similarity to, 420
examples of, 420
syntax diagram of, 420
OFFSET function
examples of, 421
syntax diagram of, 421
OLAP window functions, 481
AVG window function, 483
COUNT window function, 485
DENSE_RANK window function, 487
DISTINCT clause use of, 481
limitations, 482
MAX window function, 488
MIN window function, 490
ORDER BY clause, 481
RANK window function, 492
ROW_NUMBER window function, 493
STDDEV window function, 494
SUM window function, 495
VARIANCE window function, 497
Operators
in query execution plan, 120
OPTIONS ’e’ on Explain statement, 120
OPTIONS ’f’ on Explain statement, 120
OPTIONS ’m’ on Explain statement, 120
OPTIONS ’n’ on Explain statement, 120
ORDER BY clause
guidelines for CREATE VIEW, 102
Other functions and expressions
BITAND , 333
CASE expression, 334
CAST expression, 337
COALESCE, 342
CONVERTTOHEX, 345
CURRENT_ROLE, 354
CURRENT_USER, 357
DECODE, 371
EXPLAIN, 380
ISNULL, 387
NULLIF, 417
NVL, 419
USER, 474
Outer join, definition of, 65
P
Partitions, creating, 84
Performance
ORDER BY clause, 175
SAMPLE statement, cluster sampling, 300
PI function
examples of, 422
syntax diagram of, 422
POPULATE INDEX utility, 218
considerations for, 218
examples of, 218
syntax description of, 218
POSITION function
examples of, 423
result of, 423
syntax diagram of, 423
POWER function
examples of, 424
syntax diagram of, 424
Precision, description of, 251
Predicates
summary of, 267
BETWEEN, 267
comparison, 268
description of, 267
EXISTS, 272
IN, 273
NULL, 277
quantified comparison, 278
PREPARE statement
availability, 152
description of, 152
examples of, 152
syntax diagram of, 152
Primary key
description of, 255
PRIMARY KEY constraint, 225
Privileges
GRANT EXECUTE statement use of, 135
GRANT SCHEMA statement use of, 137
GRANT statement use of, 133
on schemas and synonyms, 139
524 Index