Oracle PL/SQL Programming

by Steven Feuerstein

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 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 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.

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

916 pages, Paperback

First published September 8, 1993

Reviews

[Kaushik Nayak · Rating 5 out of 5]

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 · Rating 5 out of 5]

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

[Dayton Outar · Rating 4 out of 5]

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

[Krystal · Rating 5 out of 5]

this book is a need

[Geir · Rating 4 out of 5]

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 · Rating 1 out of 5]

dry, technical, a reference book.

[Clay · Rating 4 out of 5]

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

[عماد المنيف · Rating 5 out of 5]

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

[Iqbal · Rating 1 out of 5]

sdsada

[Chris · Rating 2 out of 5]

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 · Rating 5 out of 5]

The best PL/SQL reference

[Mark Wheeler · Rating 3 out of 5]

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 · Rating 5 out of 5]

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

[Sravan · Rating 5 out of 5]

good