Index_P

P

package body, 380 “381

creating, 356 “357

defined, 355

package specification, 380

creating, 355 “356

defined, 355

packages, 354 “358

calling functions and procedures in, 357 “358

dropping, 358

page size , setting, 150 “151

parent key value, 254

parent node, 195

parent (master) table, 16, 254

parent-child relationship, 16

parentheses

for operator precedence, 33

in set operator order of evaluation, 187 “188

subqueries within, 166

parsing an SQL statement, 509

PARTITION BY clause, 218 “219, 236

PASSWORD command, 274

password ( user ), changing, 273 “274

PATH environment variable, 478

pattern matching against a string, 83 “88

PDF documents stored as LOBs, 428

percent character (%), 40

PERCENTILE_CONT() function, 223

PERCENTILE_DISC() function, 223

PERCENT_RANK() function, 221 “222, 234

permissions, 11

phantom reads (transactions), 264

phone column (customers table), 15

plan table

columns in, 544

creating, 542 “543

execution plan stored in, 545

querying, 545 “546

PLS-00370 error, 347

PLS_INTEGER data type, 556

PL/SQL (Procedural Language/SQL), 25 “26, 332

PL/SQL programming, 25, 331 “365

for adding business logic, 332

block structure, 332 “334

conditional logic, 335

cursors , 337 “342

DBMS_FLASHBACK package, 266

exception handling, 26, 342 “347

functions, 352 “354

loops , 335 “337

procedures, 347 “352

programming constructs, 25

statement-terminating semicolon (;), 333

using collections in, 401 “414

using LOBs from within, 434 “469

using objects in, 380 “381

variables and types, 334

PL/SQL returned values, bind variables for, 540

PL/SQL types, 334, 555 “556

pointer to a file

explained, 432

populating a BFILE column with, 433

positional notation, 237

positional and symbolic notation to access cells , 237

POSITIVE data type, 556

POSITIVEN data type, 556

pound characters (###) returned by TO_CHAR(), 81

POWER() function, 75

POWERMULTISET operator, 424

POWERMULTISET_BY_CARDINALITY operator, 424 “425

prepared SQL statements (Java), 509 “511

PreparedStatement class (Java), 487, 491, 510 “511, 520 “522

present year, 114

PRESENTNNV() function, 242

PRESENTV() function, 242

PRESERVE clause of CREATE TABLE, 294

price column (products table), 17

primary key, 15

defined, 14

populating using a sequence, 314

primary key column, duplicate value for, 253

primary key constraints, 18, 253

PRIMARY KEY keywords, 14, 18

PRINT command (SQL*Plus), 540

printStackTrace() method (Java), 499

PRIOR, using, 412

prior_address() procedure, 412

private procedures and functions, 355

privileges

granting to roles, 285 “286

making use of, 290

revoking from a role, 291

for using flashbacks, 266

Pro*C (Oracle), 4

procedures, 355

calling, 350

calling in a package, 357 “358

creating, 347 “349

dropping, 351

vs. functions, 369

getting information on, 350 “351

PL/SQL, 347 “352

public or private, 355

viewing errors in, 351 “352

procedures in a package, getting information on, 358

product_changes table, 187

product_cursor2.sql, 342

product_cursor.sql, 340 “341

product_id column (products table), 16

product_id column (purchases table), 18

product_package package, 380 “381

products table, 16 “17, 183

columns in, 16 “17

deleting rows from, 374

DML on, 372 “374

inserting rows into, 372 “373

NUMBER column, 371

rows in, 183

selecting rows from, 373 “374

updating rows in, 374

product_type_id column (products table), 16

product_type_id column (product_types table), 15

product_types table, 15 “16

pseudo column, 30

PUBLIC, granting to, 275

public procedures and functions, 355

public synonyms, 284

purchased_by column (purchases table), 36 “37

purchases tables, 17 “18

columns in, 18

DML on, 378 “380

inserting rows into, 378 “379

selecting rows from, 379

updating rows in, 379 “380

purchases_pk constraint, 18