Index

U

UCASE function, 120

UNDO error handler, 259

UNION operator, 159

calculated columns, 159

DB2, 159

MySQL, 159

resultant sets, 161

UNION ALL, 162

UNIQUE constraint, 337

unique constraints, 16

unique identifier data types, 531

see also autonumbering.

SQL Server, 533

unrepeatable reads, 289

UPDATE statement, 75

cautionary note, 77

changing values, 75

DB2, 78

expressions, 108

logging

DB2, 386

Oracle, 379

SQL Server, 372

modifying data with views, 198

MySQL, 78

object-level permissions, 305

Oracle, 78

permissions

DB2, 321

Oracle, 320

SQL Server, 311

ProductCatalog database, 432

SET keyword, 75

SQL Server, 77

stored procedure using, 433

transactions, 265

UPPER/UCASE functions, 120

urowid data type, 533

users

see also authentication; authorization.

creating/removing

DB2, 321

Oracle, 315

SQL Server, 308, 309

default users

Oracle, 315

role-based security, 454, 459

creating stored procedures, 471

creating UserRoles table, 466

creating Users table, 460

security, 301

stored procedures

creating users, 471

deleting users, 474

loading user details, 478

querying users, 476

updating users, 474

validating login, 480

USING clause, 191