Neoview SQL Reference Manual (R2.3)

NOT NULL constraint, 203
NULL predicate
examples of, 252
syntax diagram of, 251
Null symbol, 240
NULL, using, 180
NULLIF function
example of, 388
syntax diagram of, 388
NULLIFZERO function
examples of, 389
syntax diagram of, 389
NUMERIC data type, 215
Numeric data types
approximate numeric, 215
exact numeric, 215
literals, examples of, 239
Numeric literals
approximate, 238
exact, 238
examples of, 239
Numeric value expression
evaluation order, 227
examples of, 229
syntax diagram of, 227
NVL function
examples of, 390
syntax diagram of, 390
O
Object names, 206
Object namespace;Namespace, 206
Object naming statements, 43
object-privilege, general rules, 255
Objects
description of, 206
logical names, 206
OCTET_LENGTH function
CHAR_LENGTH similarity to, 391
examples of, 391
syntax diagram of, 391
OFFSET function
examples of, 392
syntax diagram of, 392
OLAP functions, 447
On Line Analytical Process functions, 447
Operators
in query execution plan, 106
OPTIONS ’e’ on Explain statement, 106
OPTIONS ’f’ on Explain statement, 106
OPTIONS ’m’ on Explain statement, 106
OPTIONS ’n’ on Explain statement, 106
outer join, definition of, 64
P
partitions, creating, 76
Performance
ORDER BY clause, 157
SAMPLE statement, cluster sampling, 272
PI function
examples of, 393
syntax diagram of, 393
PICTURE data type, character string, 211
PICTURE data type, numeric, 216
POPULATE INDEX utility, 197
considerations for, 197
examples of, 197
syntax description of, 197
POSITION function
examples of, 394
result of, 394
syntax diagram of, 394
POWER function
examples of, 395
syntax diagram of, 395
Precision, description of, 228
Predicates
summary of, 243
BETWEEN, 243
comparison, 244
description of, 243
EXISTS, 248
IN, 249
NULL, 251
quantified comparison, 252
PREPARE statement
availability, 135
examples of, 135
syntax diagram of, 135
Primary key
description of, 232
PRIMARY KEY constraint, 203
Privileges
GRANT EXECUTE statement use of, 120
GRANT SCHEMA statement use of, 122
GRANT statement use of, 118
REVOKE EXECUTE statement use of, 139
REVOKE SCHEMA statement use of, 141
REVOKE statement use of, 137
privileges on schemas and synonyms, 123
privileges on views, 119
PURGEDATA utility, 198
Q
Quantified comparison predicates
ALL, ANY, SOME, 252
examples of, 253
operand requirements, 253
result of, 253
syntax diagram of, 252
QUARTER function
examples of, 396
syntax diagram of, 396
Query execution plan
displayed, 106
operators, 106
reviewing, 106
Query expression
479