Index

P

packages, 457

parameters

default values, 220

Oracle, 221

functions, 111

input/output parameters, 225

OUT/OUTPUT keywords, 221

output parameters, 221

DB2, 224

Oracle, 222

SQL Server, 221

stored procedures, 220

parsing SQL statements, 26

PARTITION keyword

ProductCatalog database, 422, 423

use with OVER keyword, 104

PASSWORD function, 325

passwords

see authentication.

pattern matching, 57

see also LIKE keyword.

$ character, 62

* character, 29

% character, 58, 59

^ character, 62

_ character, 58, 62

{} characters, 62

Access, 61

case-sensitivity, 58

escaping reserved characters, 59

MySQL, 62

SQL Server, 61

wildcards, 58

PERCENT keyword, 95

performance

indexes, 355

Oracle triggers, 382

performance-testing plan, 356

SERIALIZABLE isolation level, 292

SQL Server triggers, 375

stored procedures, 262

triggers, 366

PermissionCategories table, 464

permissions

see also authorization; object-level permissions; role-based security; security; statement-level permissions.

bitmask values, 456

DELETE statement

DB2, 321

Oracle, 317

SQL Server, 311

extensibility, 456

flexibility, 456

granting permissions to roles, 469

granting roles to users, 466

INSERT statement

DB2, 322

MySQL, 325

Oracle, 318, 319

SQL Server, 311

SELECT statement

DB2, 322

object-level permissions, 305

Oracle, 318

SQL Server, 311

stored procedures

creating permissions, 487

deleting permissions, 488

granting permissions to roles, 492

loading permissions, 488

modifying permissions, 487

querying permissions, 490

querying permissions granted to roles, 493

querying users permissions, 493

querying users roles, 496

UPDATE statement

DB2, 321

Oracle, 320

SQL Server, 311

Permissions table, 465

phantoms, 291

PL/SQL, 7

POSSTR function, 120, 123

POWER function, 112

precedence between operators, 109

precision data type, 534

PRIMARY KEY constraint

creating tables, 335

InstantUniversity database, 515

ProductCatalog database, 401

primary keys

constraints, 11

defining relationships, 17

definition, 10

foreign key relationship illustrated, 22

inserting rows, 69

NULL, 336

ProductCatalog database, 394

relationships illustrated, 22

procedural language, 5

procedures

see stored procedures.

Product table, 399

inserting rows, 404

querying data, 406

ProductCatalog database, 389

adding data, 402

creating data structures, 395

creating tables

Category table, 398

Department table, 396

Product table, 399

ProductCategory table, 401

example query, 424

querying data, 442

relationships, 390

requirements, 390

retrieving data, 406

updating data, 432

ProductCategory table, 394, 401

inserting rows, 405

querying data, 415

Professor table, 515

inserting data, 524

profiles, 315