Neoview SQL Reference Manual (R2.4 SP2)

syntax diagram of, 72
CROSS JOIN, description of, 66, 168
CURRENT_DATE function
examples of, 362
syntax diagram of, 362
CURRENT_ROLE function
example of, 363
syntax diagram of, 363
CURRENT_TIME function
examples of, 364
precision specification within, 364
syntax diagram of, 364
CURRENT_TIMESTAMP function
examples of, 361, 365
precision specification within, 361, 365
syntax diagram of, 361, 365
CURRENT_USER function
example of, 366
syntax diagram of, 366
D
Data Definition Language (DDL) statements
summary of, 37
ALTER MATERIALIZED VIEW, 40
ALTER MVGROUP , 42
ALTER SYNONYM , 43
ALTER TABLE, 44
ALTER TRIGGER, 53
ALTER VIEW, 54
CREATE INDEX , 60
CREATE MATERIALIZED VIEW, 63
CREATE MVGROUP, 69
CREATE SCHEMA, 70
CREATE SYNONYM, 71
CREATE TABLE, 72
CREATE TRIGGER, 95
CREATE VIEW, 101
DROP INDEX, 111
DROP MATERIALIZED VIEW, 112
DROP MVGROUP, 113
DROP SCHEMA, 114
DROP SYNONYM, 115
DROP TABLE, 116
DROP TRIGGER, 117
DROP VIEW, 118
GRANT, 135
GRANT EXECUTE, 137
GRANT SCHEMA, 139
REVOKE, 155
REVOKE EXECUTE, 157
REVOKE SCHEMA, 159
Data Manipulation Language (DML) statements
summary of, 38
DELETE statement, 106
INSERT statement, 143
MERGE INTO, 150
SELECT statement, 163
TABLE statement, 196
UPDATE statement, 197
VALUES statement, 208
Data type conversion, CAST expression, 345
Data types
approximate numeric
descriptions of, 241
DOUBLE PRECISION, 242
FLOAT, 242
REAL, 242
character, 235
comparable and compatible, 233
datetime
DATE, 237
TIME, 237
TIMESTAMP, 237
exact numeric
DECIMAL, 241
descriptions of, 241
INTEGER, 241
LARGEINT, 241
NUMERIC, 241
SMALLINT, 241
extended numeric precision, 234
fixed length character
CHAR, 235
NATIONAL CHAR, 236
NCHAR, 236
interval, 239
literals, examples of
datetime literals, 263
interval literals, 266
numeric literals, 267
varying-length character
CHAR VARYING, 236
NATIONAL CHAR VARYING, 236
NCHAR VARYING, 236
VARCHAR, 236
Database object name, 230
Database objects, 229
DATE_ADD function
examples of, 367
syntax diagram of, 367
DATE_PART (of a timestamp) function
examples of, 373
syntax diagram of, 373
DATE_PART (of an interval) function
examples of, 372
syntax diagram of, 372
DATE_SUB function
examples of, 368
syntax diagram of, 368
DATE_TRUNC function
examples of, 374
syntax diagram of, 374
DATEADD function
examples of, 369
syntax diagram of, 369
DATEDIFF function
examples of, 370
syntax diagram of, 370
526 Index