Neoview SQL Reference Manual (R2.4)

on views, 134
REVOKE EXECUTE statement use of, 156
REVOKE SCHEMA statement use of, 158
REVOKE statement use of, 154
PURGEDATA utility, 219
Q
Quantified comparison predicates
ALL, ANY, SOME, 279
examples of, 279
operand requirements, 279
result of, 279
syntax diagram of, 278
QUARTER function
examples of, 425
syntax diagram of, 425
Query execution plan
displayed, 120
operators, 120
reviewing, 120
Query expression
INSERT statement use of, 142
SELECT statement use of, 166
syntax diagram of, 99, 141
Query specification
SELECT statement use of, 169
simple table, form of , 169
Quick reference, 499
R
RADIANS function
examples of, 426
syntax diagram of, 426
RANK function
examples of, 427
syntax diagram of, 427
RANK window function
examples of, 492
syntax diagram of, 492
READ COMMITTED, 28
READ UNCOMMITTED, 28
REAL data type, 239
RECOMPUTE materialized views, 64, 263
RENAME TO clause, 48
Renaming tables, 48
REPEAT function
examples of, 430
syntax diagram of, 430
REPEATABLE READ
and SERIALIZABLE, 28
description of, 35
REPLACE function
examples of, 431
syntax diagram of, 431
REQUESTS_IN, 122
Reserved
schemas for HP, 68
table names, 83
words, Neoview SQL, 501
Resource control statements , 40
EXECUTE statement, 117
LOCK TABLE statement, 147
PREPARE statement, 152
UPDATE STATISTICS statement, 202
REVOKE EXECUTE statement
authorization and availability requirements, 157
examples of, 157
syntax diagram of, 156
REVOKE SCHEMA statement
authorization and availability requirements, 160
examples of, 160
syntax diagram of, 158
REVOKE statement
authorization and availability requirements, 155
examples of, 155
privileges, 282
syntax diagram of, 154
RIGHT function
examples of, 432
syntax diagram of, 432
RIGHT join, description of, 168
Roles, 27
ROLLBACK WORK statement
syntax diagram of, 161
ROUND function
examples of, 433
syntax diagram of, 433
Row size, calculating, 84
Row value constructor
BETWEEN predicate use of, 267
comparison predicates use of, 269
IN predicate use of, 273
NULL predicate use of, 277
quantified comparison predicates use of, 278
ROW_NUMBER window function
examples of, 493
syntax diagram of, 493
ROWS SINCE CHANGED function
considerations for, 436
examples of, 436
syntax diagram of, 436
ROWS SINCE function
examples of, 434
syntax diagram of, 434
ROWS/REQUEST, 122
ROWS_OUT, 122
RPAD function
examples of, 437
syntax diagram of, 437
RTRIM function
examples of, 438
syntax diagram of, 438
RUNNINGAVG function
equivalent definition, 439
examples of, 439
syntax diagram of, 439
RUNNINGCOUNT function
examples of, 440
525