Neoview SQL Reference Manual (R2.5)

nullable keys, 80
restrictions, 79
SET table, example of, 94
suitable keys, 80
syntax diagram of, 72
CROSS JOIN, description of, 67, 169
CURRENT_DATE function
examples of, 374
syntax diagram of, 374
CURRENT_ROLE function
example of, 375
syntax diagram of, 375
CURRENT_TIME function
examples of, 376
precision specification within, 376
syntax diagram of, 376
CURRENT_TIMESTAMP function
examples of, 373, 377
precision specification within, 373, 377
syntax diagram of, 373, 377
CURRENT_USER function
example of, 378
syntax diagram of, 378
Cursors
ANSI holdable, 239
holdable, defined, 239
JDBC example, 239
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, 96
CREATE VIEW, 102
DROP INDEX, 113
DROP MATERIALIZED VIEW, 114
DROP MVGROUP, 115
DROP SCHEMA, 116
DROP SYNONYM, 117
DROP TABLE, 118
DROP TRIGGER, 119
DROP VIEW, 120
GRANT, 136
GRANT EXECUTE, 138
GRANT SCHEMA, 140
REVOKE, 156
REVOKE EXECUTE, 158
REVOKE SCHEMA, 160
Data Manipulation Language (DML) statements
summary of, 38
DELETE statement, 108
INSERT statement, 144
MERGE INTO, 151
SELECT statement, 164
TABLE statement, 197
UPDATE statement, 198
VALUES statement, 210
Data type conversion, CAST expression, 357
Data types
approximate numeric
descriptions of, 253
DOUBLE PRECISION, 254
FLOAT, 254
REAL, 254
character, 248
comparable and compatible, 245
datetime
DATE, 250
TIME, 250
TIMESTAMP, 250
exact numeric
DECIMAL, 253
descriptions of, 253
INTEGER, 253
LARGEINT, 253
NUMERIC, 253
SMALLINT, 253
extended numeric precision, 246
fixed length character
CHAR, 248
NATIONAL CHAR, 248
NCHAR, 248
interval, 251
literals, examples of
datetime literals, 276
interval literals, 279
numeric literals, 280
varying-length character
CHAR VARYING, 248
NATIONAL CHAR VARYING, 249
NCHAR VARYING, 249
VARCHAR, 248
Database object name, 242
Database objects, 241
DATE_ADD function
examples of, 379
syntax diagram of, 379
DATE_PART (of a timestamp) function
examples of, 385
syntax diagram of, 385
DATE_PART (of an interval) function
examples of, 384
syntax diagram of, 384
DATE_SUB function
examples of, 380
syntax diagram of, 380
DATE_TRUNC function
538 Index