Index

K

KEYSET cursor type, 236

keywords

see also functions; statements.

AGGREGATE, 143

ALL, 156

ALL (rows), 84

AND, 54

ANY, 157

AS, 35, 205

ASC, 46

ATOMIC, 141, 218

AUTOINCREMENT, 354

BEGIN ... END, 205

BETWEEN, 55

CALL, 203

CLOSE, 238

COMMIT, 271

CONSTRAINT, 520

CONTAINS, 442

CONTAINS SQL, 141

CROSS JOIN, 169

DEALLOCATE, 238

DECLARE, 217

DEFAULT, 221, 334

DEFAULT VALUES, 72

DELETE, 78

DESC, 46

DETERMINISTIC, 141

DISTINCT, 49, 84

ELSE/ELSEIF, 226

ESCAPE, 59

EXCEPT, 164

EXISTS, 155

FETCH, 237

FETCH FIRST, 98

GROUP BY, 90

HAVING, 92

IN, 56

INDEX, 520

INNER JOIN, 171

INSERT, 67

INTERSECT, 164

INTO, 68

IS, 205, 234

JOIN, 151, 169

LANGUAGE, 248

LIKE, 57

LIMIT, 78, 97

MINUS, 164

misuse of reserved words, 32

MODE, 469

NOT, 54

NULL, 63

ONLY, 78

OPEN, 237

OR, 54

ORDER BY, 46

OUT, 222

OUT/OUTPUT, 221

parsing statements, 26

PARTITION, 104

PERCENT, 95

REFERENCES, 518

REGEXP, 62

RLIKE, 62

RETURN, 252

ROLLBACK, 270

ROWNUM, 100

SAVEPOINT, 274

SELECT, 29

SET, 75, 219

SOME, 157

THEN, 226

TIME, 518

TIMESTAMP, 127

TOP, 94

TRANSACTION, 275

UNION, 159

UPDATE, 75

USING, 191

WHERE, 50

WITH CHECK OPTION, 198

WITH TIES, 96