Index_A

A

ABS() function, 73 “74

ACCEPT command, 155 “158

ACID transaction properties, 262

addition operator (+), 30 “32

ADD_MONTHS() function, 116 “117

aggregate functions, 62, 88 “92

GROUP BY clause with, 95

groups of rows with, 94 “95

incorrect use of, 96 “97

with ROLLUP, 205

aliases

column, 33 “34

table, 47, 532

ALL operator, 39, 172 “173

all_views view, 325

ALTER INDEX statement, 320

ALTER ROLE statment, 290

ALTER SEQUENCE statement, 315

ALTER TABLE statement, 298 “307

ALTER TRIGGER statement, 364

ALTER TYPE statement, 391

ALTER USER statement, 273

ALTER VIEW statement, 329

ampersand character (&), for temporary variable, 153

ampersands (&&), for repeated variable, 155

analytic functions, 214 “235

CUBE operator with, 220 “221

GROUPING SETS operator with, 221

PARTITION BY clause with, 218 “219

ROLLUP operator with, 219 “220

ANALYZE command, 546 “547

AND clause

with CONNECT BY PRIOR clause, 200

when accessing a range of cells , 238

AND logical operator, 42

with inner joins, 57

precedence over OR, 43

ANSI (American National Standards Institute), 3, 46,  417

ANSI SQL/86 standard syntax for joins, 46

ANSI SQL/92 standard syntax for joins, 46, 55 “60

ANSI standard date format, 102 “103

ANSI support for nested tables, 417 “425

ANY operator, 38

accessing all cells using, 238

with a multiple row subquery, 172

APPEND command, 144

APPEND() function, 441 “442

append_example() procedure, 441 “442

arithmetic, 30 “33

arithmetic operator precedence, 33

arithmetic operators, 30

combining in an expression, 32

order of execution for, 33

AS keyword, before an alias, 34

ASC keyword

with ORDER BY, 44

in OVER clause, 217

ASCII() function, 64 “65

associative arrays, 390 “391, 414 “415

asterisk character (*), 29, 144, 157

atomicity (transaction property), 262

auto-commit mode, 497

automatic database diagnostic monitoring, 549 “550

AVG() function, 90, 96, 167 “169, 174, 205, 225 “227

GROUP BY clause with, 94

WHERE clause with, 93