没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle PL_SQL Language Pocket Reference, 5th Edition.2015.pdf
资源详情
资源评论
资源推荐

Steven Feuerstein,
Bill Pribyl & Chip Dawes
Oracle
PL
/
SQL
Language
Pocket
Reference
A GUIDE TO ORACLE'S PL/SQL
LANGUAGE FUNDAMENTALS
5th Edition
Covers Oracle Database 12c

ISBN: 978-1-491-92000-8
US $15.99 CAN $18.99
Be more productive with the Oracle PL/SQL language. The fth edition of this
popular pocket reference puts the syntax of specific PL/SQL language ele-
ments right at your ngertips, including features added in Oracle Database 12c.
Whether you’re a developer or database administrator, when you need
answers quickly, the Oracle PL/SQL Language Pocket Reference will save
you hours of frustration with concise summaries of:
■ Fundamental language elements, such as block structure,
datatypes, and declarations
■ Statements for program control, cursor management, and
exception handling
■ Records, procedures, functions, triggers, and packages
■ Execution of PL/SQL functions in SQL
■ Compilation options, object-oriented features, collections,
and Java integration
Steven Feuerstein one of the world’s leading experts on the Oracle
PL/SQL language, is also the author of Oracle PL/SQL Best Practices
(O’Reilly).
Bill Pribyl, coauthor of the bestselling Oracle PL/SQL Programming, is
also a teacher and software consultant.
Chip Dawes, a consultant with PwC’s Health Industry Advisory services,
has worked with Oracle Database versions 5 through 12.
oreilly.com, Twitter: @oreillymedia
Oracle PL/SQL Language
Pocket Reference
OR ACLEDATABASES

Steven Feuerstein, Bill Pribyl, and Chip Dawes
Oracle PL/SQL Language
Pocket Reference
FIFTH EDITION

978-1-491-92000-8
[LSI]
Oracle PL/SQL Language Pocket Reference
by Steven Feuerstein, Bill Pribyl, and Chip Dawes
Copyright © 2015 Steven Feuerstein, Bill Pribyl, Chip Dawes. All rights
reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebasto‐
pol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promo‐
tional use. Online editions are also available for most titles (http://safaribook‐
sonline.com). For more information, contact our corporate/institutional sales
department: 800-998-9938 or corporate@oreilly.com.
Editor: Tim McGovern
Production Editor: Shiny Kalapurakkel
Copyeditor: Amanda Kersey
Proofreader: Kim Cofer
Indexer: Lucie Haskins
Interior Designer: David Futato
Cover Designer: Karen Montgomery
Illustrator: Rebecca Demarest
September 2015: Fifth Edition
Revision History for the Fifth Edition
2015-09-04: First Release
See http://oreilly.com/catalog/errata.csp?isbn=9781491920008 for release
details.
The O’Reilly logo is a registered trademark of O’Reilly Media, Inc. Oracle
PL/SQL Language Pocket Reference, the cover image, and related trade dress
are trademarks of O’Reilly Media, Inc.
While the publisher and the authors have used good faith efforts to ensure
that the information and instructions contained in this work are accurate, the
publisher and the authors disclaim all responsibility for errors or omissions,
including without limitation responsibility for damages resulting from the use
of or reliance on this work. Use of the information and instructions contained
in this work is at your own risk. If any code samples or other technology this
work contains or describes is subject to open source licenses or the intellec‐
tual property rights of others, it is your responsibility to ensure that your use
thereof complies with such licenses and/or rights.

Table of Contents
Introduction 1
PL/SQL Language Fundamentals 2
Variables and Program Data 12
Conditional and Sequential Control 24
Loops 30
Database Interaction 35
Cursors in PL/SQL 40
Exception Handling 54
Records in PL/SQL 62
Collections in PL/SQL 66
Built-in Functions and Packages 84
Stored Procedures and Functions 105
Triggers 120
Packages 129
Calling PL/SQL Functions in SQL 134
Object-Oriented Features 137
Compilation 152
Java Language Integration 164
Index 169
iii
剩余188页未读,继续阅读













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

评论0