Oracle PL/SQL Programming

by Steven Feuerstein

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 12"c" 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

Genres: Reference, Programming, Technology, Nonfiction, Software, Science, Technical

ebook

First published September 8, 1993

Reviews

[Kaushik Nayak]

Excellent book for PL/SQL programmers. Each section has abundant examples which cover all the scenarios. Steven feuerstein is a world renowned expert in PL/SQL language and there is no dearth of tips and tools of using the language from the master himself. This book is definitely Steven's greatest.
Along with explaining the features available in the language, it also includes advice on best practices on testing,debugging and improving the code quality. Almost all the essential tools available for a developer in PL/SQL has been clearly explained and demonstrated with examples.

Steven also created a website PL/SQL challenge which is a great platform to practice your coding skills. So, once you complete reading this book my suggestion would be to complete the PL/SQL practice tests in this site : https://plsqlchallenge.oracle.com/

[Nat]

If you’re a PL/SQL developer, you need this book.

[Dayton Outar]

Pretty good reference material for using with Oracle when creating database solution.

[Bobcat]

Published several years ago but still the best, most comprehensive book on the subject.

[Krystal]

this book is a need

[Geir]

I used this to study for the Oracle PL/SQL OCP exam (1Z0-146). Having just passed it, I feel I must recommend it for this purpose. It covers all the exam topics, and goes into further detail on several topics, which I found to be useful for filling out the gaps. It also covers topics from the previous exam (1Z0-144) which I mostly skipped over, having completed that exam earlier. It lacks any control questions after each chapter, which might have been useful.

While somewhat dry in places (unavoidable given the subject material) I found it to be thorough. A good supplement to Oracle's student guide.

[Steve lockwood]

A better question is how much I understood. Enough is the answer. About 30% is actual. I'll come back to this when I need it. I'm praying that SQL becomes all drag and drop which I suppose it moving in this direction anyways, so it's a matter of time.

[Tresuiri]

dry, technical, a reference book.

[Clay]

Excellent book, if you want to learn PL/SQL.

[عماد المنيف]

This a the plsql reference book. It's a must for any plsql programmer, I keep using it for every plsql development.

[Iqbal]

sdsada

[Chris]

I might call it a reference book but then again I am more likely to google the topic than open this book.

[Delhi Irc]

Location: ND5 IRC
Accession no: DL026831

[Victor Tsvetkov]

The best PL/SQL reference

[Mark Wheeler]

I'd done PL/SQL before but some time ago, so got this book as a reference for reviewing and understanding PL/SQL code I was working with on a new software system.

[Adderek]

Great book - although there is a newer edition.
A must-read for every PL/SQL programmer.

[Sravan]

good