Digital List Price:	$67.99
Kindle Price:	$50.99 Save $17.00 (25%)
Sold by:	Amazon.com Services LLC

You've subscribed to ! We will preorder your items within 24 hours of when they become available. When new books are released, we'll charge your default payment method for the lowest price available during the pre-order period.

Update your device or payment method, cancel individual pre-orders or your subscription at
Your Memberships & Subscriptions

There was an error. We were unable to process your subscription due to an error. Please refresh and try again.

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c by [Steven Feuerstein, Bill Pribyl]

Follow the Authors

Bill Pribyl

Steven Feuerstein

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c 6th Edition, Kindle Edition

by Steven Feuerstein (Author), Bill Pribyl (Author) Format: Kindle Edition

4.7 117 ratings

See all formats and editions

Price

New from

Used from

Kindle

"Please retry"

$50.99

—

Paperback, Illustrated

"Please retry"

$79.99

$47.51

$11.44

Kindle
$50.99 Read with Our Free App
Paperback
$27.53 - $79.99

41 Used from $11.44 24 New from $47.51

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.

Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.

Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers

ISBN-13

978-1449324452
Edition

6th
Sticky notes

On Kindle Scribe
Publisher

O'Reilly Media
Publication date

January 23, 2014
Language

English
File size

11968 KB
See all details

Due to its large file size, this book may take longer to download

Read with the free Kindle apps (available on iOS, Android, PC & Mac), Kindle E-readers and on Fire Tablet devices. See all supported devices

Steven Feuerstein
48
Kindle Edition
1 offer from $17.99
Sanjay Mishra
95
Kindle Edition
1 offer from $23.99
Steven Feuerstein
55
Kindle Edition
1 offer from $12.91
Michael McLaughlin
93
Kindle Edition
1 offer from $44.99
Kim Berg Hansen
32
Kindle Edition
1 offer from $33.99
Anthony Molinaro
152
Kindle Edition
1 offer from $41.99

Editorial Reviews

Book Description

Covers Versions Through Oracle Database 12c --This text refers to an alternate kindle_edition edition.

About the Author

Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). He has also published his first book for kids: http://stevenfeuerstein.com/vivianvulture. Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and served as PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Steven's latest initiative is the PL/SQL Challenge (http://www.plsqlchallenge.com), a daily quiz for PL/SQL developers; hundreds of programmers play each day. Check it out and join the fun! Steven's online technical cyberhome is located at www.ToadWorld.com/SF. You can also catch up on his latest, mostly non-PLSQL rants at http://feuerthoughts.blogspot.com.

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.

--This text refers to an alternate kindle_edition edition.

From the Back Cover

ORACLE PL/SQL Programming is the first book devoted exclusively to the PL/SQL language, a rich procedural extension to the Oracle RDBMS and to SQL. You'll get the basics - datatypes, control statements, exception handlers, records, and built-in functions. Beyond these basics, you'll learn the most advanced and powerful language constructs, including PL/SQL tables, cursor variables, and the wide array of built-in packages that extend PL/SQL. The book provides numerous, real-world examples and dozens of utilities you can put to use in your own applications. It also offers guidelines for an effective coding style, as well as the tips and techniques necessary to build modular, maintainable applications. --This text refers to an alternate kindle_edition edition.

From the Publisher

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a relatively new programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools, including SQL*Plus, Oracle Forms, Oracle Graphics, Oracle Reports, and Oracle Developer 2000 (formerly the Cooperative Development Environment (CDE)). It offers a myriad of data types, and such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). Originally a rather limited tool, PL/SQL is now a mature and effective language for developers. As more and more Oracle customers move from the mainframe to client- server configurations, PL/SQL is becoming ever more crucial. It provides the foundation for the code used to distribute processing and transactions across the network. PL/SQL allows the developer to: Design powerful and easy-to-use GUI interfaces in products like Oracle Forms and Oracle Graphics Build complex reports and long-running batch processes Implement critical business rules in database triggers and stored procedures Link a World Wide Web page to an Oracle database Although PL/SQL is very important to Oracle customers, it has not received the attention -- by Oracle Corporation and outside vendors and authors -- that it deserves. The only book previously available on PL/SQL is the overly concise Oracle reference manual. Training courses tend to focus on the flashy side of the new GUI tools and ignore the more complicated PL/SQL programming that is so vital to production applications. Oracle PL/SQL Programming fills a huge gap in the Oracle market. The book provides developers with a single, comprehensive guide to building applications with PL/SQL -- and building them the right way. It's packed with strategies, code architectures, tips, techniques, and fully realized code. The book comes with a disk containing many examples of PL/SQL programs that readers can use immediately or as starting points for further development. Oracle PL/SQL Programming is divided into six parts: Part I introduces PL/SQL, its many versions, the environments in which it operates, PL/SQL language fundamentals, and effective coding style. Part II describes basic PL/SQL statements for variables, cursors, conditional and sequential control, loops, exception handling, records, and tables. Part III describes all of the built-in (predefined) PL/SQL functions and procedures -- string, date, number, and miscellaneous as well as the built-in packages that come with PL/SQL. Part IV describes how to modularize your PL/SQL programs using blocks, procedures, functions, and packages. Part V describes how to debug PL/SQL programs and manage code in the database. It also contains a summary of tips for using PL/SQL most effectively. Part VI contains appendices summarizing the contents of the disk and the calling of stored procedures from Version 1.1. --This text refers to an alternate kindle_edition edition.

Product details

ASIN ‏ : ‎ B00I0GI75G
Publisher ‏ : ‎ O'Reilly Media; 6th edition (January 23, 2014)
Publication date ‏ : ‎ January 23, 2014
Language ‏ : ‎ English
File size ‏ : ‎ 11968 KB
Simultaneous device usage ‏ : ‎ Unlimited
Text-to-Speech ‏ : ‎ Enabled
Screen Reader ‏ : ‎ Supported
Enhanced typesetting ‏ : ‎ Enabled
X-Ray ‏ : ‎ Not Enabled
Word Wise ‏ : ‎ Not Enabled
Sticky notes ‏ : ‎ On Kindle Scribe
Print length ‏ : ‎ 2368 pages

Best Sellers Rank: #1,094,905 in Kindle Store (See Top 100 in Kindle Store)
- #108 in SQL Databases
- #294 in SQL (Books)
- #598 in Computer Databases

Customer Reviews:
4.7 117 ratings

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

About the authors

Follow authors to get new release updates, plus improved recommendations.

Bill Pribyl
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Discover more of the author’s books, see similar authors, read author blogs and more
See more on the author's page
Steven Feuerstein
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.
Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and has served as PL/SQL Evangelist for Quest Software since January 2001. He is an Oracle ACE Director and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Since 2005 he has focused his attention on improving the testing of PL/SQL programs, primarily through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. Steven's online PL/SQL cyberhome is located at www.ToadWorld.com/SF; but you can also find out more about Steven at http://www.StevenFeuerstein.com.
See more on the author's page

Customer reviews

4.7 out of 5

117 global ratings

5 star		82%
4 star		10%
3 star		5%
2 star		4%
1 star 0% (0%)		0%

How customer reviews and ratings work

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

G. Brandon Hoyt

Follow along with the examples to learn

Reviewed in the United States 🇺🇸 on December 8, 2021

Verified Purchase

I bought this and it sits on my desk, where i use it as a reference at least once a week. it will help you solve tricky Oracle problems, most times faster than google!

Helpful

mcj

This book is fantastic and in my opinion would be a good fit ...

Reviewed in the United States 🇺🇸 on November 26, 2017

Verified Purchase

This book is fantastic and in my opinion would be a good fit for a beginner who already has some SQL knowledge. This would be a good reference to have for any new PL/SQL developer or someone who wants to enhance their knowledge and use of Oracle database. I would recommend this as a starting point or baseline THEN (not before) using the web to get your information for more complex topics. Approaching PL/SQL in the right order will help you avoid mistakes down the line and enable you to know what to not copy and paste from the web. Oracle's website has a ton of great information, but having a book like this with examples and further explanations comes in very handy when getting exposed to/learning PL/SQL.

Reviewed in the United States 🇺🇸 on June 8, 2015

Verified Purchase

Clocking in at well over 1000 pages, Oracle PL/SQL Programming is almost mind-numbing in scope. The all-encompassing knowledge presented is the most impressive I've ever seen in a technical book.

However, after 400+ pages in, I realized I really wasn't learning PL/SQL. I was reading a lot and trying to digest as much as I could, but actual information retention was not happening. When I bough the book, I was looking for a similar resource as when I became certified in Oracle SQL: a guide to teach me via a sample schema which would allow me to code at an increasingly sophisticated level. Learn the basics, practice, and become confident enough to develop more complex queries is the way I need to learn.

One issue that became increasingly frustrating for me was the use of concepts in sample code before a novice like myself even understands the concept. Core PL/SQL features such as packages, procedures, and triggers are not even covered until more than halfway through the book. However, features such as PL/SQL blocks, records, and collections are explained via sample code using procedures, packages, and triggers. Therefore, I'm trying to understand how code works regarding a concept which has not yet been explained nor whose syntax do I understand.

Judging by its reputation, this is a much beloved reference guide and I am sure one that I will come to appreciate once I have an understanding of the PL/SQL language. However, there are better books, IMO, for learning programming concepts without feeling overwhelmed.

27 people found this helpful

Helpful

Mr. Mark S. Jones

I've had one of these since the beginning and I'm not disappointed now either.

Reviewed in the United States 🇺🇸 on April 20, 2014

Verified Purchase

I've been working with Oracle for over 20 years now and wherever I go, I have the Oracle Technical Reference and this book at least - these are like tools a car technician would have in their own car at all times.

The biggest problem I see people have with this book is trying to use it for reference and it's not really designed that way. The way the book is arranged, each topic starts with code snippets that improve as you work through them until at the end you see everything complete and I've discovered this is an awesome way to truly grok the use of the concept. Then once I've done that it's great for reference later because I can see not only how it's supposed to work, but how it evolved to work that way.

Once you get used to what the book is actually doing, you'll probably find out you want the book around all the time too.

6 people found this helpful

Helpful

Rafiq

This book is awesome. I think the title should be 'Applied Oracle ...

Reviewed in the United States 🇺🇸 on October 6, 2016

Verified Purchase

This book is awesome. I think the title should be 'Applied Oracle PL/SQL' though because it doesn't just explain core concepts or theory as I find in many other books, it actually walks you through the mind of a developer as s/he analyses and apply PL/SQL to solve real world business problems.

One person found this helpful

Helpful

James Perkins

More in depth into the inner workings of Oracle than I needed, but still good.

Reviewed in the United States 🇺🇸 on June 26, 2016

Verified Purchase

More PL/SQL for Oracle than stored procedures. More of writing code inside of a stored procedure or function call inside Oracle. Its i more in depth then I needed. I needed more information on working with Oracle from an outside perspective call the stored procedure, passing in parameters, returning record sets. This book has it but needs to expand on some things more, need more examples for quicker reference. I am use to MSSQL which is more intuitive than Oracle, but I am stuck with what is implemented. I find it interesting that when viewing a table of data from Oracle that is doesn't pull back the table ordered by the ID field, also version 11 doesn't auto increment the ID field or Key field. One has to write extra triggers and such which is old minded in my mind since other databases auto increment as a basic function. I read that version 12 now auto increments.

One person found this helpful

Helpful

Shoppingero

Not for newbies...

Reviewed in the United States 🇺🇸 on March 2, 2017

Verified Purchase

Not for beginners in my opinion... I've been reading the book and trying to run the examples (they have provided a download for that too). Sometimes I'm having a hard time looking for the code example for a section of the book because of the way it was organized... Most are found on the Chapter wise codes but some fragments of code are not that easy to find.
For a beginner you'll see a procedure having another procedure as an IN parameter or calling another procedure/ function at the earlier chapters of the book which I think a newbie will have a hard time to follow. I'm struggling with it but it has great tips especially for those who want to dig deep with pl/sql.

I'll update my review when I get in the later chapters of the book.

One person found this helpful

Helpful

Douglas Marquardson

Excellent book with great examples

Reviewed in the United States 🇺🇸 on December 7, 2014

Verified Purchase

Excellent book with great examples. It covers just abut everthing in detail. However what I would like to see is some exercises that would allow you to test what you have learned. These exercises could also be in a companion book since this book is already so large.

2 people found this helpful

Helpful

Top reviews from other countries

Translate all reviews to English

Marfitt

Very useful

Reviewed in the United Kingdom 🇬🇧 on January 12, 2016

Verified Purchase

This is a useful book. Example code is well used to complement the descriptions. It's a bit thick and I am sure it could be condensed without reducing the quality.

2 people found this helpful

Amazon Customer

Five Stars

Reviewed in the United Kingdom 🇬🇧 on June 3, 2017

Verified Purchase

Great book wading my way through it all and learning lots....

Amazon Customer

Five Stars

Reviewed in the United Kingdom 🇬🇧 on June 1, 2018

Verified Purchase

The holy bible in PL/SQL programming

F F M V

A bit long but complete!

Reviewed in Spain 🇪🇸 on June 14, 2021

Verified Purchase

The book is very long but there are a lot of superb examples to explain their ideas and techniques. There is also a little bit of humor which makes the experience better in my opinion. Content-wise it is perfect, I felt like every topic was explained or mentioned. I found their advices very helpful for my day to day programming. Remember that this version covers until 12c!

georg hickel

Gut wie erwartet

Reviewed in Germany 🇩🇪 on April 8, 2016

Verified Purchase

Hatte schon eine alte Version und habe es gekauft um mich auf den aktuellen Stand zu bringen. Es ist keine Referenz sondern ein klassischer umfassender User Guide mit best practices. Meine Erwartungen sind voll erfüllt und kann es nur empfehlen.

Amazon Music Stream millions of songs	Amazon Advertising Find, attract, and engage customers	6pm Score deals on fashion brands	AbeBooks Books, art & collectibles	ACX Audiobook Publishing Made Easy	Sell on Amazon Start a Selling Account

Amazon Business Everything For Your Business	Amazon Fresh Groceries & More Right To Your Door	AmazonGlobal Ship Orders Internationally	Home Services Experienced Pros Happiness Guarantee	Amazon Ignite Sell your original Digital Educational Resources	Amazon Web Services Scalable Cloud Computing Services

Audible Listen to Books & Original Audio Performances	Book Depository Books With Free Delivery Worldwide	Box Office Mojo Find Movie Box Office Data	ComiXology Thousands of Digital Comics	DPReview Digital Photography	Fabric Sewing, Quilting & Knitting

Goodreads Book reviews & recommendations	IMDb Movies, TV & Celebrities	IMDbPro Get Info Entertainment Professionals Need	Kindle Direct Publishing Indie Digital & Print Publishing Made Easy	Amazon Photos Unlimited Photo Storage Free With Prime	Prime Video Direct Video Distribution Made Easy

Shopbop Designer Fashion Brands	Amazon Warehouse Great Deals on Quality Used Products	Whole Foods Market America’s Healthiest Grocery Store	Woot! Deals and Shenanigans	Zappos Shoes & Clothing	Ring Smart Home Security Systems

eero WiFi Stream 4K Video in Every Room	Blink Smart Security for Every Home	Neighbors App Real-Time Crime & Safety Alerts	Amazon Subscription Boxes Top subscription boxes – right to your door	PillPack Pharmacy Simplified	Amazon Renewed Like-new products you can trust

Buy for others

Buying and sending eBooks to others

Follow the Authors

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c 6th Edition, Kindle Edition

Customers who read this book also read

Editorial Reviews

Book Description

About the Author

From the Back Cover

From the Publisher

Product details

Videos

About the authors

Bill Pribyl

Steven Feuerstein

Customer reviews

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Top reviews from other countries