Neoview SQL Reference Manual (R2.3)

INSERT statement use of, 125
SELECT statement use of, 148
syntax diagram of, 88, 124
Query specification
SELECT statement use of, 151
simple table, form of , 151
Quick reference, 457
R
RADIANS function
examples of, 397
syntax diagram of, 397
RANK function
syntax diagram of, 398
RANK window function
examples of, 452
syntax diagram of, 452
READ COMMITTED, 30
READ UNCOMMITTED, 30
REAL data type, 216
RECOMPUTE materialized views, definition of, 62
reflexive updates, 134
RENAME TO clause, 48
renaming tables, 48
REPEAT function
examples of, 401
syntax diagram of, 401
REPEATABLE READ
and SERIALIZABLE, 30
description of, 37
REPLACE function
examples of, 402
syntax diagram of, 401
REQUESTS_IN, 108
reserved table names, 75
Reserved words
Neoview SQL, 459
Resource control, statements for, 42
REVOKE EXECUTE statement
authorization and availability requirements, 140
examples of, 140
syntax diagram of, 139
REVOKE SCHEMA statement
authorization and availability requirements, 142
examples of, 142
syntax diagram of, 141
REVOKE statement
authorization and availability requirements, 138
examples of, 138
privileges, 255
syntax diagram of, 137
RIGHT function
examples of, 402
syntax diagram of, 402
RIGHT join, description of, 150
roles, 29
ROLLBACK WORK statement
syntax diagram of, 143
ROUND function
examples of, 403
syntax diagram of, 403
Row Format, 76
row size, calculating, 75
Row value constructor
BETWEEN predicate use of, 243
comparison predicates use of, 245
IN predicate use of, 249
NULL predicate use of, 251
quantified comparison predicates use of, 252
ROW_NUMBER window function
examples of, 453
syntax diagram of, 452
ROWS SINCE CHANGED function
considerations for, 405
examples of, 405
syntax diagram of, 405
ROWS SINCE function
examples of, 404
syntax diagram of, 403
ROWS/REQUEST, 108
ROWS_OUT, 108
RPAD function
examples of, 405
syntax diagram of, 405
RTRIM function
examples of, 406
syntax diagram of, 406
RUNNINGAVG function
equivalent definition, 407
examples of, 407
syntax diagram of, 406
RUNNINGCOUNT function
examples of, 407
syntax diagram of, 407
RUNNINGMAX function
examples of, 408
syntax diagram of, 408
RUNNINGMIN function
examples of, 408
syntax diagram of, 408
RUNNINGRANK function
considerations for, 398
example for, 398
syntax diagram of, 398
RUNNINGSTDDEV function
equivalent definition, 400, 411
examples of, 400, 411
syntax diagram of, 400, 411
RUNNINGSUM function
examples of, 412
syntax diagram of, 412
RUNNINGVARIANCE function
examples of, 413
syntax diagram of, 413
S
SAMPLE clause
cluster sampling, 271
480 Index