Feuerstein - Oracle PL-SQL Language Pocket Reference 4e (O'Reilly, 2008).pdf

(449 KB) Pobierz
436343936 UNPDF
FOURTH EDITION
Oracle PL/SQL Language
Pocket Reference
Steven Feuerstein, Bill Pribyl,
and Chip Dawes
Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo
436343936.005.png 436343936.006.png
Oracle PL/SQL Language Pocket Reference, Fourth Edition
by Steven Feuerstein, Bill Pribyl, and Chip Dawes
Copyright © 2008 Chip Dawes, Steven Feuerstein, and Bill Pribyl.
All rights reserved.
Printed in Canada.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North,
Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales
promotional use. Online editions are also available for most titles
( safari.oreilly.com ). For more information, contact our corporate/
institutional sales department: (800) 998-9938 or corporate@oreilly.com .
Editors: Deborah Russell
and Mary Treseler
Production Editor: Mary Brady
Proofreader: Mary Brady
Indexer: Johnna VanHoose Dinse
Cover Designer: Karen Montgomery
Interior Designer: David Futato
Illustrator: Robert Romano
Printing History:
April 1999:
First Edition.
February 2003:
Second Edition.
October 2007:
Fourth Edition.
NutshellHandbook,theNutshellHandbooklogo,andtheO’Reillylogoare
registered trademarks of O’Reilly Media, Inc. The Pocket Reference series
designations, OraclePL/SQLLanguagePocketReference , the image of ants,
and related trade dress are trademarks of O’Reilly Media, Inc. Many of the
designationsusedbymanufacturersandsellerstodistinguishtheirproducts
are claimed as trademarks. Where those designations appear in this book,
and O’Reilly Media, Inc. was aware of a trademark claim, the designations
have been printed in caps or initial caps. Oracle® and all Oracle-based
trademarks and logos are trademarks or registered trademarks of Oracle
Corporation, Inc. in the United States and other countries. O’Reilly Media,
Inc. is independent of Oracle Corporation. Java and all Java-based
trademarks and logos are trademarks or registered trademarks of Sun
Microsystems,Inc.intheUnitedStatesandothercountries.O’ReillyMedia,
Inc. is independent of Sun Microsystems, Inc.
While every precaution has been taken in the preparation of this book, the
publisher and authors assume no responsibility for errors or omissions, or
for damages resulting from the use of the information contained herein.
ISBN-10: 0-596-51404-2
ISBN-13: 978-0-596-51404-4
[TM]
April 2004:
Third Edition.
436343936.007.png
Contents
Introduction
1
Acknowledgments
1
Conventions
2
PL/SQL Language Fundamentals
2
PL/SQL Character Set
2
Identifiers
3
Boolean, Numeric, and String Literals
4
Numeric Literals
5
Datetime Interval Literals
6
Delimiters
6
Comments
8
Pragmas
8
Statements
9
Block Structure
9
Variables and Program Data
11
Scalar Datatypes
12
LOB Datatypes
18
Implicit Datatype Conversions
19
NULLs in PL/SQL
19
Declaring Variables
19
Anchored Declarations
22
Programmer-Defined Subtypes
23
iii
436343936.008.png 436343936.001.png 436343936.002.png
Conditional and Sequential Control
23
Conditional Control Statements
23
Sequential Control Statements
27
Loops
28
Simple Loop
29
Numeric FOR Loop
29
Cursor FOR Loop
30
WHILE Loop
30
REPEAT UNTIL Loop Emulation
31
EXIT Statement
31
CONTINUE Statement (Oracle Database 11g)
31
Loop Labels
33
Database Interaction
34
Sequences in PLSQL
34
Transaction Management
34
Autonomous Transactions
37
Cursors in PL/SQL
38
Explicit Cursors
38
Implicit Cursors
42
Dynamic Cursors
45
DBMS_SQL
46
SQL Injection and Bind Variables
47
Cursor Variables
48
Cursor Expressions
49
Exception Handling
50
Declaring Exceptions
51
Raising Exceptions
53
Scope
54
Propagation
54
iv
|
Contents
436343936.003.png
Records in PL/SQL
56
Declaring Records
57
Referencing Fields of Records
58
Assigning Records
58
Records and DML
59
Nested Records
60
Collections in PL/SQL
61
Declaring a Collection
63
Initializing a Collection
64
Adding and Removing Elements
65
Nested Table Functions
65
Collection Methods
68
Collections and Privileges
71
Nested Collections
71
Bulk Binds
71
Built-in Functions and Packages
75
Built-in Functions
75
Built-in Regular Expression Functions
87
Built-in Packages
93
Stored Procedures and Functions
97
Procedures
98
Functions
99
Parameters
100
Local Programs
103
Program Overloading
104
Forward Declarations
106
Table Functions
106
Function Result Cache
107
Privileges and Stored PL/SQL
109
Contents
|
v
436343936.004.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin