Neoview SQL Reference Manual (R2.4 SP2)

result of, 428
syntax diagram of, 428
POWER function
examples of, 429
syntax diagram of, 429
Precision, description of, 254
Predicates
summary of, 273
BETWEEN, 273
comparison, 274
description of, 273
EXISTS, 278
IN, 279
LIKE, 281
NULL, 283
quantified comparison, 284
PREPARE statement
availability, 153
considerations for, 153
examples of, 153
syntax diagram of, 153
PRIMARY KEY constraint, 227
Primary key, description of, 260
Privileges
GRANT EXECUTE statement use of, 137
GRANT SCHEMA statement use of, 139
GRANT statement use of, 135
on schemas and synonyms, 141
on views, 136
REVOKE EXECUTE statement use of, 157
REVOKE SCHEMA statement use of, 159
REVOKE statement use of, 155
PURGEDATA utility
considerations for, 220
example of, 221
syntax diagram of, 220
Q
Quantified comparison predicates
ALL, ANY, SOME, 285
examples of, 285
operand requirements, 285
result of, 285
syntax diagram of, 284
QUARTER function
examples of, 430
syntax diagram of, 430
Query execution plan
displayed, 122
operators, 122
reviewing, 122
Query expression
SELECT statement use of, 166
Query specification
SELECT statement use of, 169
simple table, form of , 169
R
RADIANS function
examples of, 431
syntax diagram of, 431
RANK window function
examples of, 490
syntax diagram of, 490
RANK/RUNNINGRANK function
example for, 432
syntax diagram of, 432
READ COMMITTED, 25
READ UNCOMMITTED, 25
REAL data type, 242
Recalibrating the current value
ALTER TABLE statement, 49
CREATE TABLE LIKE, 83
example of, 83
RECOMPUTE materialized views, 65, 268
Referential integrity
FOREIGN KEY constraint, 46, 47, 76, 77, 227
RENAME TO clause, 47
Renaming tables, 47
REPEAT function
examples of, 435
syntax diagram of, 435
REPEATABLE READ
and SERIALIZABLE, 26
description of, 33
REPLACE function
examples of, 436
syntax diagram of, 436
REQUESTS_IN, 124
Reserved
schemas for HP, 70
table names, 86
words, Neoview SQL, 507
Resource control statements , 38
EXECUTE statement, 119
LOCK TABLE statement, 148
PREPARE statement, 153
UPDATE STATISTICS statement, 203
REVOKE EXECUTE statement
authorization and availability requirements, 158
considerations for, 158
examples of, 158
syntax diagram of, 157
REVOKE SCHEMA statement
authorization and availability requirements, 161
considerations for, 161
examples of, 161
syntax diagram of, 159
REVOKE statement
authorization and availability requirements, 156
considerations for, 156
examples of, 156
privileges, 288
syntax diagram of, 155
RIGHT function
examples of, 437
syntax diagram of, 437
RIGHT join, description of, 169
533