Neoview SQL Reference Manual (R2.4)

CROSS join, description of, 168
CURRENT_DATE function
examples of, 353
syntax diagram of, 353
CURRENT_ROLE function
example of, 354
syntax diagram of, 354
CURRENT_TIME function
examples of, 355
precision specification within, 355
syntax diagram of, 355
CURRENT_TIMESTAMP function
examples of, 352, 356
precision specification within, 352, 356
syntax diagram of, 352, 356
CURRENT_USER function
example of, 357
syntax diagram of, 357
D
Data Definition Language (DDL) statements
summary of, 39
ALTER MATERIALIZED VIEW, 42
ALTER MVGROUP , 43
ALTER SYNONYM , 44
ALTER TABLE, 46
ALTER TRIGGER, 52
ALTER VIEW, 53
COMMIT WORK, 58
CREATE INDEX , 59
CREATE MATERIALIZED VIEW, 61
CREATE MVGROUP, 67
CREATE SCHEMA, 68
CREATE SYNONYM, 69
CREATE TABLE, 70
CREATE TRIGGER, 93
CREATE VIEW, 99
DROP INDEX, 109
DROP MATERIALIZED VIEW, 110
DROP MVGROUP, 111
DROP SCHEMA, 112
DROP SYNONYM, 113
DROP TABLE, 114
DROP TRIGGER, 115
DROP VIEW, 116
GRANT, 133
GRANT EXECUTE, 135
GRANT SCHEMA, 137
REVOKE, 154
REVOKE EXECUTE, 156
REVOKE SCHEMA, 158
Data Manipulation Language (DML) statements
summary of, 40
DELETE statement, 105
INSERT statement, 141
SELECT statement, 163
UPDATE statement, 196
Data type conversion, CAST expression, 337
Data types
approximate numeric
descriptions of, 238
DOUBLE PRECISION, 239
FLOAT, 239
REAL, 239
character, 233
comparable and compatible, 231
datetime
DATE, 235
TIME, 235
TIMESTAMP, 235
exact numeric
DECIMAL, 239
descriptions of, 238
INTEGER, 239
LARGEINT, 239
NUMERIC, 238
SMALLINT, 239
extended numeric precision, 232
fixed length character
CHAR, 233
NATIONAL CHAR, 234
NCHAR, 234
interval, 237
literals, examples of
datetime literals, 258
interval literals, 261
numeric literals, 262
varying-length character
CHAR VARYING, 234
NATIONAL CHAR VARYING, 234
NCHAR VARYING, 234
VARCHAR, 234
Database object names, 228
Database object namespace, 228
Database objects, 227
DATE_ADD function
examples of, 358
syntax diagram of, 358
DATE_PART (of a timestamp) function
examples of, 364
syntax diagram of, 364
DATE_PART (of an interval) function
examples of, 363
syntax diagram of, 363
DATE_SUB function
examples of, 359
syntax diagram of, 359
DATE_TRUNC function
examples of, 365
syntax diagram of, 365
DATEADD function
examples of, 360
syntax diagram of, 360
DATEDIFF function
examples of, 361
syntax diagram of, 361
DATEFORMAT function
examples of, 362
518 Index