Neoview SQL Reference Manual (R2.4 SP2)

COUNT function use of, 359
MAX function use of, 407
MAXIMUM function use of, 407
MIN function use of, 408
STDDEV function use of, 457
SUM function use of, 461
VARIANCE function use of, 473
DML statements (see Data Manipulation Language (DML)
statements)
Documents, related information, 21
DOUBLE PRECISION data type, 242
DROP INDEX statement
authorization and availability requirements, 111
considerations for, 111
example of, 111
syntax diagram of, 111
DROP MATERIALIZED VIEW statement
example of, 112
syntax diagram of, 112
DROP MVGROUP statement
example of, 113
syntax diagram of, 113
DROP SCHEMA statement
authorization and availability requirements, 114
considerations for, 114
example of, 114
syntax diagram of, 114
DROP SYNONYM statement
considerations for, 115
example of, 115
syntax diagram of, 115
DROP TABLE statement
authorization and availability requirements, 116
considerations for, 116
examples of, 116
syntax diagram of, 116
DROP TRIGGER statement
authorization requirements, 117
considerations for, 117
example of, 117
syntax diagram of, 117
DROP VIEW statement
authorization and availability requirements, 118
considerations for, 118
example of, 118
syntax diagram of, 118
DROP VOLATILE INDEX statement
examples of, 111
syntax diagram of, 111
DROP VOLATILE TABLE statement
authorization requirements, 116
examples of, 116
syntax diagram of, 116
E
Embedded INSERT
examples of, 182
restrictions on, 173
Error messages, 35
EST_TOTAL_COST field, 126
EXCLUSIVE lock mode, 27
EXECUTE statement
considerations for, 120
examples of, 120
scope of, 120
syntax diagram of, 119
EXISTS predicate
correlated subquery within, 278
examples of, 278
syntax diagram of, 278
EXP function
examples of, 388
syntax diagram of, 388
EXPLAIN function
columns in result, 389
examples of, 391
operator tree, 389
syntax diagram of, 389
EXPLAIN output columns
CARDINALITY, 129
DESCRIPTION, 129
DETAIL_COST, 129
EST_TOTAL_COST, 126
LEFT_CHILD_SEQ_ NUM, 128
MODULE_NAME, 128
OPERATOR, 128
OPERATOR_COST, 129
PLAN_ID, 128
REQUESTS_IN, 124
RIGHT_CHILD_ SEQ_NUM, 128
ROWS_OUT, 124
SEQ_NUM, 128
STATEMENT_NAME, 128
TNAME, 129
TOTAL_COST, 129
Explain statement
displayed, 122
examples of, 123, 125, 126, 129
JDBC example, 131
ODBC example, 130
operators, 122
OPTIONS ’e’ considerations, 126
OPTIONS ’f’ considerations, 123
OPTIONS ’m’ considerations, 128
OPTIONS ’n’ considerations, 124
output, 124
reviewing query execution plans, 122
syntax, 122
Expression
character (or string) value, 243
datetime value, 245, 246, 250
description of, 243
interval value, 246, 250
numeric value, 253
Extended numeric precision, 234
Extensions, statements, 34
EXTRACT function
examples of, 392
528 Index