Neoview SQL Reference Manual (R2.3)

CREATE TABLE use of, 72, 268
examples of, 269
syntax diagram of, 268
DEFAULT value, using, 126, 180
DEGREES function
examples of, 344
syntax diagram of, 344
DELETE statement
access options, 92
SET ON ROLLBACK clause, 92
SET ROLLBACK clause, 92
SKIP CONFLICT access, 93
STREAM clause, 92, 180
syntax diagram of, 91
WHERE clause, 92
DELETE statement (embedded)
searched form, 91
Delimited identifiers, 230
DENSE_RANK window function
examples of, 450
syntax diagram of, 449
Derived column names
examples of, 201
syntax of, 201
DETAIL_COST in EXPLAIN output
CPU_TIME, 113, 351
IDLETIME, 113, 352
IO_TIME, 113, 351
MSG_TIME, 113, 351
PROBES, 113, 352
DIFF1 function
equivalent definitions, 345
examples of, 345
syntax diagram of, 345
DIFF2 function
equivalent definitions, 347
examples of, 347
syntax diagram of, 347
DISK POOL , 78
considerations for, 78
restrictions for, 78
DISTINCT clause
aggregate functions, 155, 289
AVG function use of, 303
COUNT function use of, 321
MAX function use of, 372
MAXIMUM function use of, 372
MIN function use of, 373
STDDEV function use of, 420
SUM function use of, 424
VARIANCE function use of, 441
DML operations on materialized views
restrictions for, 64
DML statements (see Data Manipulation Language (DML)
statements)
Documents, related information, 26
DOUBLE PRECISION data type, 216
DROP INDEX statement
authorization and availability requirements, 95
examples of, 95
supporting a constraint, 95
syntax diagram of, 95
DROP MATERIALIZED VIEW statement
syntax diagram of, 96
DROP MVGROUP statement
example of, 97
DROP MVGROUP statement, syntax description of, 97
DROP SCHEMA statement
authorization and availability requirements, 98
examples of, 98
syntax diagram of, 98
DROP SYNONYM statement, 99
syntax diagram of, 99
DROP SYNONYM statements
considerations, 99
DROP TABLE statement
authorization and availability requirements, 100
examples of, 100
syntax diagram of, 100
DROP TRIGGER statement
authorization and availability requirements, 101
syntax diagram of, 101
DROP VIEW statement
authorization and availability requirements, 102
examples of, 102
syntax diagram of, 102
DROP VOLATILE INDEX statement
examples of, 95
supporting a constraint, 95
syntax diagram of, 95
DROP VOLATILE TABLE statement
authorization and availability requirements, 100
examples of, 100
syntax diagram of, 100
E
embedded inserts, restrictions on, 155
error messages, 39
EST_TOTAL_COST field, 110
EXCLUSIVE lock mode, 31
EXECUTE statement
considerations for, 104
examples of, 104
scope of, 104
syntax diagram of, 103
EXISTS predicate
correlated subquery within, 248
examples of, 248
syntax diagram of, 248
EXP function
examples of, 349
syntax diagram of, 349
EXPLAIN function
columns in result, 350
examples of, 352
operator tree, 350
syntax diagram of, 350
EXPLAIN output columns
475