没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle PL SQL Recipes.pdf
资源详情
资源评论
资源推荐



Oracle and PL/SQL
Recipes
A Problem-Solution Approach
Josh Juneau
Matt Arena

Oracle and PL/SQL Recipes: A Problem-Solution Approach
Copyright © 2010 by Josh Juneau and Matt Arena
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-3207-0
ISBN-13 (electronic): 978-1-4302-3208-7
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol
with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only
in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of
the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are
not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject
to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Development Editor: Jonathan Gennick
Technical Reviewer: Bob Bryla
Editorial Board: Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Gennick,
Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes, Jeffrey Pepper, Frank
Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Coordinating Editor: Adam Heath
Copy Editor: Kim Wimpsett
Compositor: Bytheway Publishing Services
Indexer: BIM Indexing & Proofreading Services
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media, LLC., 233 Spring Street,
6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-
ny@springer-sbm.com, or visit www.springeronline.com.
For information on translations, please e-mail rights@apress.com, or visit www.apress.com.
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our
Special Bulk Sales–eBook Licensing web page at www.apress.com/info/bulksales.
The information in this book is distributed on an “as is” basis, without warranty. Although every
precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have
any liability to any person or entity with respect to any loss or damage caused or alleged to be caused
directly or indirectly by the information contained in this work.
The source code for this book is available to readers at www.apress.com.

iii
Contents at a Glance
About the Authors............................................................................................ xxxiv
About the Technical Reviewer .......................................................................... xxxv
Acknowledgments ........................................................................................... xxxvi
Introduction ................................................................................................... xxxviii
Chapter 1: PL/SQL Fundamentals ...........................................................................1
Chapter 2: Essential SQL.......................................................................................15
Chapter 3: Looping and Logic ...............................................................................43
Chapter 4: Functions, Packages, and Procedures ...............................................63
Chapter 5: Triggers...............................................................................................93
Chapter 6: Type Conversion................................................................................119
Chapter 7: Numbers, Strings, and Dates ............................................................133
Chapter 8: Dynamic SQL .....................................................................................155
Chapter 9: Exceptions.........................................................................................187
Chapter 10: PL/SQL Collections and Records .....................................................215
Chapter 11: Automating Routine Tasks ..............................................................233
Chapter 12: Oracle SQL Developer......................................................................247
Chapter 13: Analyzing and Improving Performance...........................................281
Chapter 14: Using PL/SQL on the Web ................................................................291
Chapter 15: Java in the Database.......................................................................319
Chapter 16: Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython...............345
Chapter 17: Unit Testing With utPLSQL...............................................................361
Index...................................................................................................................391
剩余456页未读,继续阅读

















安全验证
文档复制为VIP权益,开通VIP直接复制

评论5