Oracle PL/SQL Programming

最新推荐文章于 2024-03-13 22:10:43 发布

原创最新推荐文章于 2024-03-13 22:10:43 发布 · 509 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #triggers #transactions #inheritance #database #structure

Oracle 专栏收录该内容

75 篇文章

订阅专栏

本书全面介绍了 Oracle PL/SQL 的各种特性及其应用，包括基础语法、数据类型、事务管理等内容，并新增了 Java 方法调用、自主事务等主题。适合希望深入了解 PL/SQL 的数据库开发者。

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

If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.

Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest.

Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

http://rapidshare.com/files/51354660/0596009771.zip