Index_A

A

abstraction, 9

Access

basics of, 330

ODBC and, 23, 23

aggregate operations, defined, 85

alert log files, 290–293, 291

aliases

column renaming and, 27

defined, 27

table aliases, 97

ALL_ data dictionary view, 212

ALL_IND_COLUMNS view, 214

ALL_INDEXES view, 214

ALL_OBJECTS view, 214–215

ALL_TAB_COLUMNS view, 213–214

ALL_TABLES view, 213

ALTER INDEX statement, 248, 249

ALTER statement, 37–38

AND operator

precedence, 51

WHERE clause and, 74–75

Apache, and hosting iSQL*Plus, 20

application design, and Oracle’s Tuning Methodology, 242

application tuning, SQL, 256–261

Explain Plan tool, 257–258, 258

Oracle optimizer, 258–261

Top SQL tool, 256–257, 256–257

ASC keyword, 84

associative tables, 7

attributes, assigning, 8

auditing

basics of, 234

object auditing, 236–237

statement auditing, 234–236