I/O, and Oracle’s Tuning Methodology, 242
IBM DB2/UDB, 329
identifiers for accounts, 224
IMP. See Import utility (IMP)
implicit conversion, defined, 55
Import utility (IMP)
DBAs and, 276–281, 277
users and, 271–273
IMS, 3
IN operator
Import utility (IMP) and, 79–80
WHERE clause and, 76, 120
incremental backups, RMAN, 284
index-organized tables (IOTs), 246
indexes, 243–251
creating, dropping and maintaining, 208–210, 247–248
data dictionary index information, 250–251
defined, 208
monitoring, 248–250
types of, 244–247, 244, 246
when to create, 243
inheritance, 10
INITCAP function, 53, 54
inner joins, and INTERSECT operator, 132
INSERT statement, 32–33
instances
creating, 171–172, 171–172
defined, 158
failures of, 268
naming, 172, 172–173
OEM and, 176, 176
interface options for reporting, 180–181, 181
INTERSECT set operator, 130–132
intersection tables, 7
IOTs (index-organized tables), 246
IS NULL and IS NOT NULL, 81–82
iSQL*Plus
basics of, 18–20, 19–20
configuration for reporting, 180–184, 180
Change Password, 184
interface options, 180–181, 181
system variables, 182–184, 182
vs. SQL*Plus, 19–20, 19–20
italics in syntax, 24