Index

E

ELSE/ELSEIF keywords, 226

Embedded SQL (ESQL)

CONNECT statement, 512

empty string, 119

enabling triggers, 382

encryption, role-based security, 459

creating Users table, 460

Enrollment table, 521

inserting data, 526

entities

defining table relationships, 17

relational databases, 7

tables, 8

entity relationship (E-R) diagram

InstantUniversity database, 513

enum data type, 536

equi-joins, 169

aliases, 177

JOIN keyword, 169

multiple tables, 172

nested joins, 174

non-equi joins, 175

error handling

Oracle transactions, 280

SQL Server transactions, 277

stored procedures, 252

DB2, 258

Oracle, 255

SQL Server, 253

ERROR system variable

SQLServer transactions, 253, 278

ESCAPE keyword, 59

escaping reserved characters, 59

event triggers, 363

Exam table, 519

inserting data, 525

EXCEPT operator, 164

DB2, 165

EXCEPTION block, 255

exceptions

see error handling.

exclusive OR keyword, 109

EXEC/EXECUTE keyword, 203, 204

object-level permissions

DB2, 321

Oracle, 317

SQL Server, 311

ProductCatalog database, 434

executing transactions, 270

EXISTS operator, 155

EXIT error handler, 259

exponents, 113

expressions

Boolean expressions, 110

operators, using, 108

UPDATE statement, 108

using, 109

extensibility

bitmasked access mode, 455

permissions, 456

external data types, 535