Oracle PL/SQL Language Pocket Reference
by Feuerstein, StevenEdition: 3rd
Format: Paperback
Pub. Date: 2004-04-01
Publisher(s): Oreilly & Associates Inc
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $9.95
Rent Book
Select for Price
Rent Digital
$8.39*
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
The third edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 10g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.
Author Biography
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.
Bill Pribyl, author, teacher, and software consultant,is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all published by O'Reilly & Associates. An Oracle user since 1986, Bill has consulted on many aspects of using Oracle products. He recently spearheaded PLNet.org, a Web-based repository where developers can share open source PL/SQL.
Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. He is currently a consultant with D&D Technologies, a Chicago consultancy. He enjoys working with, lecturing on, and writing about Oracle database administration, client server application development, and Unix system administration. Chip is an Oracle Certified Professional and earned computer science and aerospace engineering degrees from St. Louis University.
Table of Contents
| Introduction | p. 1 |
| Acknowledgments | p. 2 |
| Conventions | p. 2 |
| PL/SQL Language Fundamentals | p. 2 |
| PL/SQL Character Set | p. 2 |
| Identifiers | p. 3 |
| Boolean, Numeric, and String Literals | p. 4 |
| Numeric Literals | p. 5 |
| Datetime Interval Literals | p. 5 |
| Delimiters | p. 6 |
| Comments | p. 7 |
| Pragmas | p. 8 |
| Statements | p. 9 |
| Block Structure | p. 9 |
| Variables and Program Data | p. 11 |
| Scalar Datatypes | p. 11 |
| NLS Character Datatypes | p. 17 |
| LOB Datatypes | p. 17 |
| Implicit Datatype Conversions | p. 18 |
| NULLs in PL/SQL | p. 18 |
| Declaring Variables | p. 18 |
| Anchored Declarations | p. 21 |
| Programmer-Defined Subtypes | p. 22 |
| Conditional and Sequential Control | p. 22 |
| Conditional Control Statements | p. 22 |
| Sequential Control Statements | p. 26 |
| Loops | p. 27 |
| Simple Loop | p. 27 |
| Numeric FOR Loop | p. 28 |
| Cursor FOR Loop | p. 29 |
| WHILE Loop | p. 29 |
| REPEAT UNTIL Loop Emulation | p. 30 |
| EXIT Statement | p. 30 |
| Loop Labels | p. 30 |
| Database Interaction | p. 31 |
| Transaction Management | p. 31 |
| Autonomous Transactions | p. 34 |
| Cursors in PL/SQL | p. 35 |
| Explicit Cursors | p. 35 |
| Implicit Cursors | p. 39 |
| Dynamic Cursors | p. 42 |
| Cursor Variables | p. 43 |
| Cursor Expressions | p. 44 |
| Exception Handling | p. 46 |
| Declaring Exceptions | p. 46 |
| Raising Exceptions | p. 48 |
| Scope | p. 49 |
| Propagation | p. 49 |
| Records in PL/SQL | p. 52 |
| Declaring Records | p. 52 |
| Referencing Fields of Records | p. 53 |
| Assigning Records | p. 53 |
| DML and Records | p. 54 |
| Nested Records | p. 55 |
| Named Program Units | p. 56 |
| Procedures | p. 56 |
| Functions | p. 57 |
| Parameters | p. 58 |
| Triggers | p. 72 |
| Creating Triggers | p. 73 |
| Trigger Predicates | p. 76 |
| DML Events | p. 76 |
| DDL Events | p. 77 |
| Database Events | p. 77 |
| Packages | p. 77 |
| Package Structure | p. 78 |
| Referencing Package Elements | p. 80 |
| Package Data | p. 80 |
| SERIALLY_REUSABLE Pragma | p. 80 |
| Package Initialization | p. 81 |
| Calling PL/SQL Functions in SQL | p. 82 |
| Calling a Function | p. 83 |
| Requirements and Restrictions | p. 84 |
| Calling Packaged Functions in SQL | p. 84 |
| Column/Function Name Precedence | p. 85 |
| Oracle's Object-Oriented Features | p. 85 |
| Object Types | p. 86 |
| Type Inheritance | p. 87 |
| Methods | p. 88 |
| Methods in Subtypes | p. 91 |
| Manipulating Objects in PL/SQL and SQL | p. 93 |
| Upcasting and Downcasting | p. 94 |
| Changing Object Types | p. 97 |
| Collections | p. 99 |
| Declaring a Collection | p. 101 |
| Initializing a Collection | p. 102 |
| Adding and Removing Elements | p. 103 |
| Nested Table Functions | p. 104 |
| Collection Methods | p. 107 |
| Collections and Privileges | p. 110 |
| Nested Collections | p. 110 |
| Bulk Binds | p. 110 |
| External Procedures | p. 114 |
| Creating an External Procedure | p. 114 |
| Parameters | p. 120 |
| Java Language Integration | p. 124 |
| Example | p. 125 |
| Publishing Java to PL/SQL | p. 126 |
| Data Dictionary | p. 128 |
| Regular Expressions (Oracle Database 10g) | p. 128 |
| Metacharacters | p. 128 |
| REGEXP_LIKE | p. 129 |
| REGEXP_INSTR | p. 130 |
| REGEXP_SUBSTR | p. 131 |
| REGEXP_REPLACE | p. 132 |
| Match Modifiers | p. 133 |
| Reserved Words | p. 133 |
| Index | p. 135 |
| Table of Contents provided by Ingram. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.