Learning Oracle PL/SQL

Bill Pribyl0596001800

Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle’s premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications.Among our best-selling books on PL/SQL, Learning Oracle PL/SQL is the first one a newcomer to the language will want to read. Beginning with a discussion of what PL/SQL is and what it’s good for, this book then presents language features, one at a time, in an engaging and readable way. A consistent and understandable example application-the development of a library’s electronic catalog system-runs through the chapters.Topics include: * Why use PL/SQL at all? * Fundamental components of the language * Fast ways to read and write Oracle data * Organizing code for reusability * Using PL/SQL to generate web-based applications * Making sure your PL/SQL application is secure against hackers * Benefits of using third-party developer tools * Interacting with the internet (e.g., sending email from the database) * New PL/SQL features in Oracle9i Learning Oracle PL/SQL introduces PL/SQL in a way that’s useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.

---

Table of contents :
Local Disk……Page 0
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 1
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 5
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 7
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 8
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 9
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 10
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 12
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 13
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 14
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 17
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 19
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 20
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 22
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 23
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 32
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 39
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 43
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 44
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 47
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 52
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 57
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 65
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 74
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 79
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 86
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 89
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 96
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 97
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 101
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 112
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 117
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 123
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 132
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 137
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 139
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 141
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 150
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 174
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 175
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 176
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 177
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 180
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 193
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 198
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 214
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 223
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 224
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 236
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 253
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 254
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 264
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 277
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 283
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 292
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 298
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 299
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 304
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 308
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 318
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 329
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 334
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 336
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 339
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 353
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 358
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 364
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 368
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 388
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 396
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 397
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 399
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 401
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 403
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 404
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 440
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 441
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 447
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 451
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 457
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 463
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 467
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 469
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 471
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 473
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 476
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 477
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 478
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 482
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 484
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 487
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 491
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 499
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 500
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 504
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 512
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 515
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 519
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 521
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 523
Learning Oracle PL/SQL | © 2002 O’Reilly | by KnowledgeLiberation……Page 524