Beginning PL/SQL: From Novice to Professional

最新推荐文章于 2016-12-20 15:40:15 发布

原创最新推荐文章于 2016-12-20 15:40:15 发布 · 575 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#debugging #documentation #features #statistics #testing #variables

Sql Language 专栏收录该内容

46 篇文章

订阅专栏

本书由拥有20多年经验的作者Don Bales撰写，重点介绍PL/SQL的常用部分，包括变量、数据类型、游标操作等内容。通过实际案例帮助读者掌握如何编写可维护、模块化的PL/SQL程序单元。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.

Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.

Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What you'll learn
*How important SQL is in PL/SQL
*How to use PL/SQL in both a relational and object-relational setting
*How to create maintainable, modular, and reusable PL/SQL program units
*The importance of testing as you go, and of building a permanent test plan for each module
*The importance of building debugging capabilities into your code and building a permanent debug facility for each module
*The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
*How to apply modular PL/SQL to solve real-world problems

http://rapidshare.com/files/68857982/1590598822.zip
http://depositfiles.com/files/2329568