Oracle PL/SQL Programming: Guide to Oracle8i Features (Paperback)

Steven Feuerstein

  • 出版商: O'Reilly
  • 出版日期: 1999-10-11
  • 定價: $1,050
  • 售價: 1.9$199
  • 語言: 英文
  • 頁數: 264
  • 裝訂: Paperback
  • ISBN: 1565926757
  • ISBN-13: 9781565926752
  • 相關分類: OracleSQL
  • 立即出貨(限量)

買這商品的人也買了...

商品描述

Oracle8i, the long-awaited "Internet database" from Oracle Corporation, has hit the streets running--and you may find yourself struggling to keep up with Oracle's fast-moving technology. Oracle boasts that Oracle8i offers more than 150 new features, many of them designed to make its popular database programming language, PL/SQL, faster, more powerful, and easier to use.

This concise and engaging book is both a companion to Oracle PL/SQL Programming (widely recognized as the "bible" for PL/SQL developers) and a guide designed to bring you up to speed as quickly as possible on the new PL/SQL features of Oracle8i. Following the style of Feuerstein's earlier books, the Guide to Oracle8i Features combines easy-to-understand descriptions of the new Oracle8i features with a wealth of interesting and informative examples.

The major Oracle8i PL/SQL features include the following:


  • Autonomous transactions--the ability to commit or roll back changes without affecting the "main" transaction in the rest of your session

  • Invoker rights--At compilation time, you can now decide whether a program (or all programs in a package) should run under the authority of the definer or the invoker of that program

  • Native dynamic SQL--A native implementation of dynamic SQL that's faster and easier than the DBMS_SQL built-in package

  • Bulk binds and collects--A major performance improvement that lets you process multiple rows in a single operation

  • System-level database triggers--With this feature and Advanced Queueing (AQ), you can take advantage of the publish/subscribe capabilities of Oracle8i

  • Fine-grained access control--This feature lets you implement security policies with functions and then use those functions to implement row-level security on tables or views.

  • Many new and enhanced built-in packages--New packages include DBMS_JAVA, DBMS_PROFILER, DBMS_TRACE, and more. DBMS_UTILITY, DBMS_AQ, and others have been enhanced as well.

  • Calling Java methods from within PL/SQL--The book includes enough Java know-how to help you build simple Java classes, load them into the Oracle8i database, and leverage those classes from within your PL/SQL code.



Some PL/SQL developers are uneasy about what the introduction of Java means to their applications--and their programming future. But the two languages are expected to work well together in Oracle8i. You'll be able to take advantage of all the power of Java without giving up the performance and usability advantages of PL/SQL!

Included with this book is a diskette containing an online tool developed by RevealNet, Inc., that provides point-and-click access to approximately 100 files of reusable source code and examples.

The Guide to Oracle8i Features showcases all the powerful new features of Oracle8i designed especially for PL/SQL developers. You'll find it indispensable as you strive to take the fullest possible advantage of everything this exciting new version has to offer.

Table of Contents:

  1. Oracle8i: A Bounty for PL/SQL Developers

  2. Choose Your Transaction!

  3. Invoker Rights: Your Schema or Mine?

  4. Native Dynamic SQL in Oracle8i

  5. Bulking Up with PL/SQL 8.1

  6. New Trigger Features in Oracle8i

  7. New and Enhanced Built-in Packages in Oracle8i

  8. Deploying Fine-Grained Access Control

  9. Calling Java from PL/SQL

  10. More Goodies for Oracle PL/SQL Developers

商品描述(中文翻譯)

Oracle8i,這款期待已久的「網際網路資料庫」由Oracle Corporation推出,已經上市了,你可能會發現自己在努力跟上Oracle快速發展的技術。Oracle自豪地宣稱,Oracle8i提供了150多個新功能,其中許多功能旨在使其流行的資料庫程式語言PL/SQL更快、更強大、更易於使用。

這本簡潔而引人入勝的書既是《Oracle PL/SQL程式設計》的伴侶(被廣泛認為是PL/SQL開發人員的「聖經」),也是一本旨在讓您盡快了解Oracle8i的新PL/SQL功能的指南。《Guide to Oracle8i Features》遵循Feuerstein先前書籍的風格,結合易於理解的Oracle8i新功能描述和豐富有趣的示例。

主要的Oracle8i PL/SQL功能包括以下內容:
- 自主交易:在不影響會話中的「主要」交易的情況下提交或回滾變更的能力
- 調用者權限:在編譯時,您現在可以決定一個程式(或包中的所有程式)是否在該程式的定義者或調用者的權限下運行
- 本地動態SQL:比DBMS_SQL內建套件更快、更容易使用的動態SQL本地實現
- 批量綁定和收集:一個重大的性能改進,允許您在一個操作中處理多行
- 系統級資料庫觸發器:通過此功能和高級佇列(AQ),您可以利用Oracle8i的發布/訂閱功能
- 細粒度訪問控制:此功能允許您使用函數實現安全策略,然後使用這些函數在表或視圖上實現行級安全性。
- 許多新的和增強的內建套件:新的套件包括DBMS_JAVA、DBMS_PROFILER、DBMS_TRACE等。DBMS_UTILITY、DBMS_AQ等也得到了增強。
- 從PL/SQL內部調用Java方法:本書包含足夠的Java知識,以幫助您構建簡單的Java類,將它們加載到Oracle8i資料庫中,並從PL/SQL代碼中利用這些類。

一些PL/SQL開發人員對Java的引入對他們的應用程序和編程未來感到不安。但是在Oracle8i中,這兩種語言預計能夠很好地協同工作。您將能夠充分利用Java的所有功能,同時不放棄PL/SQL的性能和易用性優勢!

本書附帶一個由RevealNet, Inc.開發的線上工具的磁片,該工具提供點擊式訪問約100個可重複使用的源代碼和示例文件。

《Guide to Oracle8i Features》展示了專為PL/SQL開發人員設計的Oracle8i的所有強大新功能。在您努力充分利用這個令人興奮的新版本的一切時,您會發現它是不可或缺的。

目錄:
1. Oracle8i:PL/SQL開發人員的豐富之地
2. 選擇您的交易!
3. 調用者權限:您的模式還是我的?
4. Oracle8i中的本地動態SQL
5. 用PL/SQL 8.1增強性能
6. Oracle8i中的新觸發器功能
7. Oracle8i中的新和增強內建套件
8. 部署細粒度訪問控制
9. 從PL/SQL調用Java
10. Oracle PL/SQL開發人員的更多好東西