Oracle Database 10g SQL (Osborne ORACLE Press Series)
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