Index

B

BACKUP statements, 314

BDB table type, 283

BEFORE triggers, 364, 365

DB2, 382

NO CASCASE BEFORE trigger, 382

Oracle, 375, 377

SQL Server, 367

BEGIN ... END block

DB2, 214

Oracle, 206

SQL Server, 205

BEGIN/BEGIN TRANSACTION commands, 269

autocommit mode, 272

SQL Server, 275

BETWEEN keyword, 55

bfile data type, 533

bigint data type

DB2, 535

MySQL, 536

SQL Server, 532

binary data

encryption, 459

binary data types, 531

Access, 537

DB2, 534

MySQL, 535

Oracle, 533

SQL Server, 532

BIT data type, 399

DB2 example, 449

ProductCatalog database, 400

SQL Server example, 445

bit data types, 531

MySQL, 535

Oracle, 533

SQL Server, 532

bitmasks

bitmask values, 456

bitmasked access mode, 455

role-based security, 495

bitwise operators, 109

BLOB (binary large object) data type

DB2, 534

MySQL, 535

Oracle, 533

ProductCatalog database, 400

boolean data types, 537

Boolean expressions, 108

expression building, 109

Boolean values

bitmasks, 455

business applications

front end operation, 2

wrapping SQL, 7

business rules

triggers, 366

byte data type

Access, 537

Oracle, 533