1、Oracle Database 11g PL/SQL ProgrammingMore free ebooks : http:/fast-This page intentionally left blank More free ebooks : http:/fast-Oracle Database 11g PL/SQL ProgrammingMichael McLaughlinNew York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney
2、 TorontoMore free ebooks : http:/fast-Copyright 2008 by The McGraw-Hill Companies, Inc. All rights reserved. Manufactured in the United States of America. Exceptas permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any formor by a
3、ny means, or stored in a database or retrieval system, without the prior written permission of the publisher. 0-07-164356-7The material in this eBook also appears in the print version of this title: 0-07-149445-6.All trademarks are trademarks of their respective owners. Rather than put a trademark s
4、ymbol after every occurrence of a trade-marked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringe-ment of the trademark. Where such designations appear in this book, they have been printed with initial caps. McGraw-Hill eBooks ar
5、e available at special quantity discounts to use as premiums and sales promotions, or for use in corporatetraining programs. For more information, please contact George Hoare, Special Sales, at george_hoaremcgraw- or (212)904-4069. TERMS OF USE This is a copyrighted work and The McGraw-Hill Companie
6、s, Inc. (“McGraw-Hill”) and its licensors reserve all rights in and to thework. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store andretrieve one copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, mo
7、dify, create derivative worksbased upon, transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without McGraw-Hills prior con-sent. You may use the work for your own noncommercial and personal use; any other use of the work is strictly prohibited. Your rightto use
8、 the work may be terminated if you fail to comply with these terms. THE WORK IS PROVIDED “AS IS.” McGRAW-HILL AND ITS LICENSORS MAKE NO GUARANTEES OR WARRANTIESAS TO THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED FROM USING THEWORK, INCLUDING ANY INFORMATION THAT CAN BE ACCESSED
9、 THROUGH THE WORK VIA HYPERLINK OR OTH-ERWISE, AND EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TOIMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. McGraw-Hill and its licen-sors do not warrant or guarantee that the functions contained in th
10、e work will meet your requirements or that its operation will beuninterrupted or error free. Neither McGraw-Hill nor its licensors shall be liable to you or anyone else for any inaccuracy, error oromission, regardless of cause, in the work or for any damages resulting therefrom. McGraw-Hill has no r
11、esponsibility for the con-tent of any information accessed through the work. Under no circumstances shall McGraw-Hill and/or its licensors be liable for anyindirect, incidental, special, punitive, consequential or similar damages that result from the use of or inability to use the work, evenif any o
12、f them has been advised of the possibility of such damages. This limitation of liability shall apply to any claim or cause what-soever whether such claim or cause arises in contract, tort or otherwise. DOI: 10.1036/0071494456More free ebooks : http:/fast-We hope you enjoy thisMcGraw-Hill eBook! Ifyo
13、ud like more information about this book,its author, or related books and websites,please click here.ProfessionalWant to learn more?More free ebooks : http:/fast-To Lisa, my eternal companion, inspiration, wife, and best friend; and to Sarah, Joseph, Elise, Ian, Ariel, Callie, Nathan, Spencer, and C
14、hristianneour terrifi c heaven-sent children. Thank you for your constant support, patience, and sacrifi ce that made writing yet another book possible.More free ebooks : http:/fast-About the AuthorMichael McLaughlin is a professor at BYUIdaho in the Computer Information Technology Department of the
15、 Business and Communication College. He is also the founder of T.Michael worked at Oracle Corporation for over eight years in consulting, development, and support. He is the inventor of the ATOMS transaction architecture (U.S. Patents #7,206,805 and #7,290,056). The patents are assigned to Oracle Co
16、rporation.Prior to his tenure at Oracle Corporation, Michael worked as an Oracle developer, systems and business analyst, and DBA beginning with Oracle 6. He is the author of Oracle Database 10g Express Edition PHP Web Programming.He is also the co-author of Oracle Database AJAX & PHP Web Applicatio
17、n Development, Oracle Database 10g PL/SQL Programming, and ExpertOracle PL/SQL.About the Technical EditorA. Scott Mikolaitis is an Applications Architect at Oracle Corporation and has worked at Oracle for over ten years. He works on prototyping and standards development for the SOA technology in Ora
18、cle Fusion.Scott also enjoys working with web services in Java as well as Jabber for human and system interaction patterns. He spends his spare time on DIY home improvement and gas-fueled RC cars.More free ebooks : http:/fast-Contents at a GlancePART IPL/SQL Fundamentals1 Oracle PL/SQL Overview . .
19、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 PL/SQL Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253 Language Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
20、 . . . . . . . . . . . 454 Control Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 915 Error Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131PART IIPL/SQL Programming6 Fun
21、ctions and Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1637 Collections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2078 Large Objects . . . . . . . . . . . . . . . . . . . . . . . .
22、. . . . . . . . . . . . . . . . . . . . . . . . . . . . 2659 Packages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31310 Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
23、 . . . . . 343PART IIIPL/SQL Advanced Programming11 Dynamic SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38112 Intersession Communication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41713 External Proc
24、edures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44514 Object Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47515 Java Libraries . . . . . . . . . . . . . . . . . . . . . . . . . . .
25、 . . . . . . . . . . . . . . . . . . . . . . . . . 50516 Web Application Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 533viiMore free ebooks : http:/fast-viii Oracle Database 11g PL/SQL ProgrammingPART IVAppendixesA Oracle Database Administration Primer .
26、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 571B Oracle Database SQL Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599C PHP Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
27、29D Oracle Database Java Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 685E Regular Expression Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 729F Wrapping PL/SQL Code Primer . . . . . . . . . . . . . . . . . . . .
28、. . . . . . . . . . . . . . . . . . 747G PL/SQL Hierarchical Profiler Primer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 753H PL/Scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 765I PL/SQL Reserved Words
29、and Keywords . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 769J PL/SQL Built-in Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 777Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 821More free ebooks : http:/fast-
