Neoview SQL Reference Manual (R2.2)

examples of, 219
syntax diagram of, 217
NVL function
examples of, 379
syntax diagram of, 379
O
Object names, 196
Object namespace;Namespace, 196
Object naming statements, 43
object-privilege, general rules, 245
Objects
description of, 196
logical names, 196
OCTET_LENGTH function
CHAR_LENGTH similarity to, 380
examples of, 380
syntax diagram of, 380
OFFSET function
examples of, 381
syntax diagram of, 381
Operators
in query execution plan, 104
OPTIONS ’e’ on Explain statement, 104
OPTIONS ’f’ on Explain statement, 104
OPTIONS ’m’ on Explain statement, 104
OPTIONS ’n’ on Explain statement, 104
outer join, definition of, 64
P
partitions, creating, 75
Performance
ORDER BY clause, 154
SAMPLE statement, cluster sampling, 262
PI function
examples of, 382
syntax diagram of, 382
PICTURE data type, character string, 201
PICTURE data type, numeric, 206
POPULATE INDEX utility, 186
considerations for, 186
examples of, 186
syntax description of, 186
POSITION function
examples of, 383
result of, 383
syntax diagram of, 383
POWER function
examples of, 384
syntax diagram of, 384
Precision, description of, 218
Predicates
summary of, 233
BETWEEN, 233
comparison, 234
description of, 233
EXISTS, 238
IN, 239
NULL, 241
quantified comparison, 242
PREPARE statement
availability, 132
examples of, 132
syntax diagram of, 132
Primary key
description of, 222
PRIMARY KEY constraint, 193
Privileges
GRANT EXECUTE statement use of, 117
GRANT SCHEMA statement use of, 119
GRANT statement use of, 115
REVOKE EXECUTE statement use of, 136
REVOKE SCHEMA statement use of, 138
REVOKE statement use of, 134
privileges on schemas and synonyms, 120
privileges on views, 116
PURGEDATA utility, 187
Q
Quantified comparison predicates
ALL, ANY, SOME, 242
examples of, 243
operand requirements, 243
result of, 243
syntax diagram of, 242
QUARTER function
examples of, 385
syntax diagram of, 385
Query execution plan
displayed, 104
operators, 104
reviewing, 104
Query expression
INSERT statement use of, 122
SELECT statement use of, 145
syntax diagram of, 87, 121
Query specification
SELECT statement use of, 148
simple table, form of , 148
Quick reference, 435
R
RADIANS function
examples of, 386
syntax diagram of, 386
RANK function
syntax diagram of, 387
READ COMMITTED, 30
READ UNCOMMITTED, 30
REAL data type, 206
RECOMPUTE materialized views, definition of, 62
reflexive updates, 131
RENAME TO clause, 48
renaming tables, 48
REPEAT function
examples of, 390
syntax diagram of, 390
REPEATABLE READ
457