Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) (Paperback)

~ (Author), (Author), (Author)
Key Phrases: external procedures, database interaction, match modifiers, Language Pocket Reference, Oracle Database, Oracle's Object-Oriented Features (more...)

Editorial Reviews

Product Description

The fourth 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 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

About the Author

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 is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.

Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences. Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP: Oracle8i DBA SQL Study Guide.

---

Product Details Paperback: 170 pages Publisher: O'Reilly Media; 4 edition (October 23, 2007) Language: English ISBN-10: 0596514042 ISBN-13: 978-0596514044 Product Dimensions: 6.8 x 4.2 x 0.5 inches Shipping Weight: 5.6 ounces (View shipping rates and policies) Average Customer Review: 3.9 out of 5 stars  See all reviews (10 customer reviews) Amazon.com Sales Rank: #114,866 in Books (See Bestsellers in Books) Popular in this category: (What's this?) #13 in  Books > Computers & Internet > Databases > Oracle > PL & SQL This item is part of The O'Reilly Pocket Guides Series.

---

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Steven Feuerstein

Bill Pribyl

Chip Dawes

Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!

Search Inside This Book:

---

Inside This Book (learn more)
Browse and search another edition of this book.

Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
external procedures, database interaction, match modifiers, returned nested table, named program units, explicit cursors, ref cursor, autonomous transaction, executable section, call spec, cursor variable, cursor name, package specification, main transaction, stored functions, nested tables

Key Phrases - Capitalized Phrases (CAPs): (learn more)
Language Pocket Reference, Oracle Database, Oracle's Object-Oriented Features, Exception Handling, Language Fundamentals, That's Entertainment, Oracle Net, Regular Expressions, Pocket Reference

Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!

Search Inside This Book:

---

What Do Customers Ultimately Buy After Viewing This Item?

	67% buy the item featured on this page: Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) 3.9 out of 5 stars (10) $10.19
	18% buy Oracle PL/SQL Programming (Animal Guide) 4.1 out of 5 stars (90) $44.09
	6% buy Oracle PL/SQL Best Practices 3.9 out of 5 stars (14) $19.79
	4% buy Oracle SQL Plus Pocket Reference (Pocket Reference (O'Reilly)) 4.0 out of 5 stars (5) $9.95

Explore similar items

---

Tags Customers Associate with This Product  (What's this?) Click on a tag to find related items, discussions, and people. Check the boxes next to the tags you consider relevant or enter your own tags in the field below.  database management systems(1) database programming(1) dba(1) pocket(1) sql(1) Agree with these tags? Your tags: Add your first tag

Search Products Tagged with   See most popular tags

---

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

---

 

Customer Reviews

10 Reviews 5 star:  (4) 4 star:  (3) 3 star:  (2) 2 star:    (0) 1 star:  (1)           Average Customer Review 3.9 out of 5 stars (10 customer reviews)		Share your thoughts with other customers:
Most Helpful Customer Reviews 21 of 23 people found the following review helpful: 3.0 out of 5 stars Only "OK", May 18, 2000 By  Andrew Harbick (Harrisonburg, VA) - See all my reviews (REAL NAME)    This review is from: Oracle PL/SQL Language Pocket Reference (Paperback) I've worked with Oracle for quite a while, and I've tinkered with PL/SQL, triggers, etc. on and off during the time that I used Oracle. Recently, I needed to write a really simple PL/SQL program to assist in doing a backfill. I bought this book expecting to pluck out details quickly for writing this program. Unfortunately, there was no index, and the table of contents was a little too high-level to help you find specific information. Finally, once you locate an appropriate section, the text is terse and the examples are quite basic. I concede that I probably should've bought "Oracle PL/SQL Language" the book for which this is a reference for my particular need. Just beware, however, that this book is solely a reference, and is hard to use unless you already know PL/SQL. 11 of 11 people found the following review helpful: 5.0 out of 5 stars Great pocket reference, 2nd edition WITH INDEX now, April 3, 2003 By  Gregor Theis (Meerbusch Deutschland) - See all my reviews (REAL NAME)    This review is from: Oracle PL/SQL Language Pocket Reference (Paperback) This small booklet "ORACLE PL/SQL Language Pocket Reference" in this new 2nd edition is exactly what you need as PL/SQL (PL/SQL is the ORACLE procedural language extension of SQL) programmer (and is even more important for casual PL/SQL programmer). "ORACLE PL/SQL Language Pocket Reference" assumes that you are running at least ORACLE 8i and it covers ORACLE 9i as well (ORACLE 9i features are marked as such). The content and coverage of the book is very good from my perspective. Even the more exotic features that I just can't remember, like e.g. the AUTHID stuff for PL/SQL procedures, are covered in this book. Even if you do not remember the exact keyword to look something up in the index, the book is still small enough to brose over every page in a couple of minutes to find your solution. All of the ORACLE 9i features (that I know of) are explained like e.g. "bulk binds" (cool PL/SQL performance feature). The language and the new index are very good. Even though this is a relatively small book, there are examples for almost every topic covered (although not big ones). This is NOT the right book to learn PL/SQL and it will not teach you any SQL. If you want to learn PL/SQL, I recommend the other books (by the same authors) from O'Reilly that are all VERY good. 8 of 8 people found the following review helpful: 3.0 out of 5 stars Handy but could be easier to access topics, June 4, 1999 By A Customer This review is from: Oracle PL/SQL Language Pocket Reference (Paperback) There is no index and only a scanty table of contents. You are forced to go to the area and browse for information. It is a short book, and scanning works, but an index would be more efficient.		Ad feedback   Most Recent Customer Reviews 4.0 out of 5 stars Good But Tough To Condense The 'Oracle PL/SQL Language Pocket Reference' is a good pocket reference for Oracle 11g but I feel that this subject matter is tough to condense in size. Read more Published 16 months ago by Daniel McKinnon 5.0 out of 5 stars New sections on Oracle's built-in functions rounds out the update. Steven Feuerstein, Bill Pribyl and Chip Dawes' ORACLE PL/SQL LANGUAGE POCKET REFERENCE provides the fourth edition of a popular pocket guide which will serve as a quick reference... Read more Published 21 months ago by Midwest Book Review 5.0 out of 5 stars Excellent reference for PL/SQL programming Oracle PL/SQL Language Pocket Reference Steven Feuerstein O'Reilly - 4th Edition http://www.oreilly.com/catalog/9780596514044/index. Read more Published 23 months ago by J. Druin 1.0 out of 5 stars anO'REILLY flop Where's the index?? A REFERENCE is something you pick up to find a particular needed peice of information. Read more Published on August 28, 2002 by K. Ambrose 4.0 out of 5 stars Nice, compact, but it really needs an index! A good sidekick for when you have a mental lapse, unfortunately they seem to have forgot to print the index. Read more Published on April 2, 2002 by G. Vajnadepava 4.0 out of 5 stars All it needs is an Index! An index would make this pocket reference 5 stars. The TOC - (Table of Contents) is helpful but an Index would be better in addition to the TOC. Gio Published on March 28, 2000 by gjaram 5.0 out of 5 stars Boris Belous Excellent partner for quick lookup. Concise, precise and to the point. While not a complete reference, it servers its purpose well: quick lookup of on the fly syntax questions. Read more Published on May 17, 1999 Search Customer Reviews Only search this product's reviews

---

Customer Discussions

This product's forum Discussion Replies Latest Post No discussions yet Ask questions, Share opinions, Gain insight Start a new discussion Topic: First post: Receive e-mail when new posts are made Prompts for sign-in   Guidelines Search Customer Discussions Search all Amazon discussions

The SQL community Latest activity 2 days ago 567 customers have contributed 330 products, 31 lists & guides and more... › Explore the community The Oracle community Latest activity 1 day ago 572 customers have contributed 397 products, 57 lists & guides and more... › Explore the community Related forums database oracle (1 discussion) oreilly books (2 discussions) sql Explore more › See all Customer Communities › Your communities

---

Listmania!

Developer Books: A list by Robert M. Garrett "Robert Garrett"   Expertos Quest Software en Oracle 2009: A list by Jorge Alfaro Bolaños   The best books for Oracle DBAs and developers - 10g update: A list by ivorykeyer Create a Listmania! list

Search Listmania!

---

So You'd Like to...

Use Oracle PL/SQL: A guide by Clark B. Timmins "q-25" Create a guide

Search Guides

---

Product Information from the Amapedia Community

Beta (What's this?)

Be the first person to add an article about this item at Amapedia.com.

› See featured Amapedia.com articles

---

Look for Similar Items by Category

• Books > Computers & Internet > Databases > Database Management Systems
• Books > Computers & Internet > Databases > Oracle > PL & SQL
• Books > Computers & Internet > Databases > SQL
• Books > Computers & Internet > Programming > Languages & Tools
• Books > Computers & Internet > Software
• Books > Reference

---

Look for Similar Items by Subject

Search Books by subject:
Database programming
Oracle
Reference works
Database Engineering
Sql (Programming Language)
Computers
Computers - Data Base Management
Computers - General Information
Computer Books: Database
Computers / Data Processing / General
Computers / Database Management / General
Computers / Programming Languages / SQL
Data Processing - General
Database Management - Oracle
Programming Languages - SQL
Database Management - General
Oracle (Computer file)
Oracle (Computer software)
Relational databases
Computing: Professional & Programming


i.e., each book must be in subject 1 AND subject 2 AND ...

Ad feedback

 

Feedback If you need help or have a question for Customer Service, contact us.  Would you like to update product info or give feedback on images? Is there any other feedback you would like to provide? Your comments can help make our site better for everyone. Please note that we are unable to respond directly to all feedback submitted via this form, but we'll ask you to sign in so we can contact you if needed.

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

› View and edit your browsing history

Get to Know Us Careers Investor Relations Press Releases Amazon and Our Planet Make Money with Us Sell on Amazon Join Associates Self-publish with Us › See all Let Us Help You Shipping Rates & Policies Amazon Prime Returns Help

Canada | China | France | Germany | Japan | United Kingdom  And don't forget: Amazon Windowshop | AmazonWireless | Askville | Audible | DPReview | Endless | IMDb | Shopbop | SoundUnwound | Warehouse Deals by Amazon | Zappos Conditions of Use | Privacy Notice  © 1996-2009, Amazon.com, Inc. or its affiliates

Product Details

• Paperback: 170 pages
• Publisher: O'Reilly Media; 4 edition (October 23, 2007)
• Language: English
• ISBN-10: 0596514042
• ISBN-13: 978-0596514044
• Product Dimensions: 6.8 x 4.2 x 0.5 inches
• Shipping Weight: 5.6 ounces (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #114,866 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #13 in

  Books > Computers & Internet > Databases > Oracle > PL & SQL

• This item is part of The O'Reilly Pocket Guides Series.

Customer Reviews

Most Helpful Customer Reviews

21 of 23 people found the following review helpful:

3.0 out of 5 stars Only "OK", May 18, 2000

By	Andrew Harbick (Harrisonburg, VA) - See all my reviews (REAL NAME)

This review is from: Oracle PL/SQL Language Pocket Reference (Paperback)

I've worked with Oracle for quite a while, and I've tinkered with PL/SQL, triggers, etc. on and off during the time that I used Oracle. Recently, I needed to write a really simple PL/SQL program to assist in doing a backfill. I bought this book expecting to pluck out details quickly for writing this program. Unfortunately, there was no index, and the table of contents was a little too high-level to help you find specific information. Finally, once you locate an appropriate section, the text is terse and the examples are quite basic.

I concede that I probably should've bought "Oracle PL/SQL Language" the book for which this is a reference for my particular need. Just beware, however, that this book is solely a reference, and is hard to use unless you already know PL/SQL.

11 of 11 people found the following review helpful:

5.0 out of 5 stars Great pocket reference, 2nd edition WITH INDEX now, April 3, 2003

By	Gregor Theis (Meerbusch Deutschland) - See all my reviews (REAL NAME)

This review is from: Oracle PL/SQL Language Pocket Reference (Paperback)

This small booklet "ORACLE PL/SQL Language Pocket Reference" in this new 2nd edition is exactly what you need as PL/SQL (PL/SQL is the ORACLE procedural language extension of SQL) programmer (and is even more important for casual PL/SQL programmer).

"ORACLE PL/SQL Language Pocket Reference" assumes that you are running at least ORACLE 8i and it covers ORACLE 9i as well (ORACLE 9i features are marked as such).

The content and coverage of the book is very good from my perspective. Even the more exotic features that I just can't remember, like e.g. the AUTHID stuff for PL/SQL procedures, are covered in this book. Even if you do not remember the exact keyword to look something up in the index, the book is still small enough to brose over every page in a couple of minutes to find your solution. All of the ORACLE 9i features (that I know of) are explained like e.g. "bulk binds" (cool PL/SQL performance feature).

The language and the new index are very good.

Even though this is a relatively small book, there are examples for almost every topic covered (although not big ones).

This is NOT the right book to learn PL/SQL and it will not teach you any SQL. If you want to learn PL/SQL, I recommend the other books (by the same authors) from O'Reilly that are all VERY good.

8 of 8 people found the following review helpful:

3.0 out of 5 stars Handy but could be easier to access topics, June 4, 1999

By A Customer

This review is from: Oracle PL/SQL Language Pocket Reference (Paperback)

There is no index and only a scanty table of contents. You are forced to go to the area and browse for information. It is a short book, and scanning works, but an index would be more efficient.