Index

I

IDENTITY keyword

autonumbering, 350, 354

ProductCatalog database, 396, 398

IDENTITY variable, 471, 483

IDENTITY_VAL_LOCAL function

ProductCatalog database, 440

role-based security, 483

IF ... ELSE statement, 226

image data type, 532

implicit cursors, 238, 242

implicit transactions, 275

see also automatic-transactions mode.

IN keyword, 56

multiple row subqueries, 152

ProductCatalog database, 424

subqueries, 147

INDEX keyword

DB2, 321

InstantUniversity database, 520

Oracle, 317

ProductCatalog database, 398, 402

indexes, 355

creating, 356

dropping, 357

performance, 356

unique or non-unique, 356

INNER JOIN keyword, 171, 178, 187

Access, 171

MySQL, 171, 173

ProductCatalog database, 415–418, 425–426

inner joins, 178

outer joins compared, 428

InnoDB table type, 283

ProductCatalog database, 397

input/output parameters, 225

INSERT statement, 67

columns not specified, 72

creating tables, 332

default values, 69

DEFAULT VALUES keywords, 72

EXEC keyword, 74

InstantUniversity database, 523

INTO keyword, 68

logging

DB2, 383

Oracle, 376

SQL Server, 368, 370

modifying data with views, 198

multi-row insert, 73

NULL data, 69, 333

object-level permissions, 305

permissions

DB2, 322

MySQL, 325

Oracle, 318, 319

SQL Server, 311

primary keys, 69

ProductCatalog database, 402, 403

single row, insert, 68

stored procedure, using, 435, 437, 438

subqueries, 154

timestamping, 69

InstantUniversity database, 513

checking data insertion, 527

Class table, 517

Course table, 515

creating tables, 515

Enrollment table, 521

entity relationship diagram, 513

Exam table, 519

INSERT statements, 523

Professor table, 515

Room table, 516

Student table, 519

StudentExam table, 522

INSTEAD OF triggers, 364, 365

DB2, 382

Oracle, 375

SQL Server, 367

INSTR function, 120

ProductCatalog database, 444

int/integer data types, 14

Access, 537

DB2, 535

MySQL, 536

Oracle, 534

SQL Server, 532

INT/INTEGER functions, 136

integrated security, 309

integrity

see also referential integrity.

constraints, 11

enforcing table integrity, 12

RDBMS role, 11

relational integrity, 18

INTERSECT operator, 164

interval data types, 534

INTO keyword

INSERT statement, 68

INVALID_NUMBER exception, 256

IS keyword, 205

cursors, 234

ISAM table type, 283

isolation levels

see transaction isolation levels.

isolation property, transactions, 273

isolation, transactions, 268