Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
Oracle Database 10g PL/SQL Programming Paperback – October 7, 2004
|New from||Used from|
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
From the Inside Flap
Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. Youll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions. Plus, youll get insider programming tips and techniques and real-world examples from the Oracle community.
Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements Regulate and recover from errors using exceptions and exception handlers Deploy subprograms, procedures, functions, packages, and triggers Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT Write object-oriented PL/SQL applications Manage large sets of data using PL/SQL records and objects Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining Automate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAIL
From the Back Cover
Write Robust PL/SQL Applications
Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You’ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions. Plus, you’ll get insider programming tips and techniques and real-world examples from the Oracle community.
- Develop, tune, and debug PL/SQL programs that access Oracle databases from a wide variety of environments
- Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements
- Regulate and recover from errors using exceptions and exception handlers
- Deploy subprograms, procedures, functions, packages, and triggers
- Accomplish intersession communication with DBMS_PIPE and DBMS_ALERT
- Write object-oriented PL/SQL applications
- Manage large sets of data using PL/SQL records and objects
- Work with Oracle Net Services, external procedures, Java libraries, and C shared libraries
- Perform object-oriented programming using transient objects, inheritance, type evolution, and attribute chaining
- Automate database tasks with DBMS_JOB and DBMS_SCHEDULER and add e-mail functionality with UTL_SMTP and UTL_MAIL
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
This book begins exactly the way experienced developers would expect-it starts out at a running pace. The book takes the next hundred-or-so pages just discussing PL/SQL basics. Where this book excels is in its examples. Each and every PL/SQL principle is clearly illustrated with many clear and relevant examples. The author then begins into a discussion of advanced PL/SQL techniques, which includes a discussion of cursors, built-in functions, and records.
The middle section of the book covers management and syntax of Oracle packages and functions. This excellent discussion covers such issues as package scope and permissions. This discussion naturally leads into advanced PL/SQL techniques including transactions, pipes, and various built-in DBMS packages. Finally, the book rounds out its PL/SQL discussions by reviewing use of Large Objects (LOB). In this section, the author discusses use and retrieval of data in this format.
I would highly recommend this book to experienced Oracle or even non-Oracle developers who want to sharpen their PL/SQL skills or who are looking for a really good PL/SQL reference. This is a must-have book for anyone serious about their PL/SQL development work.
I read the first ten chapters of this book sequentially in order to prepare for the exam, and (with the obvious exception of chapters five and six) really enjoyed the material. I think the book is well written: the organization is excellent and the examples are very clear and concise. I especially liked the summaries comparing and contrasting one construct or approach to another. The book is addressed to individuals that have programming and SQL experience, but I think it could be used by a database beginner as well.
If you're studying for 1Z0-147, my advice is: read this book (chapters 1 - 10, 16) then read the Oracle Application Developer's Guide - Fundamentals, Part II: PL/SQL (Procedure & Packages, Dynamic SQL, and Triggers). Getting an online study guide helps as well as you can train for the exam is an environment virtually identical to the one in which the exam is given.
The book is written more as a corporate training manual than that of a programming text book. As probably everyone who ever took a training class from their company knows, training is often done by people who not only are not educators, but may not actually understand or have even used the subject of the training. It is intentional that such people do not state the concepts abstractly - they only know concrete examples and maybe only the example in their pre-written material.
This book fits this description to a T. It does not specify the correct syntax except in examples. It does not specify the qualifications and conditions governing the language elements or the examples. As such, unless you are essentially copying an example almost verbatim, you have no real knowledge of whether your code will compile, let alone work as intended. As an example consider their discussion of SELECT statements. They speak about the Select clause, the INTO clause, etc. Nowhere do they state that the list of items in the INTO clause should separated by commas. Although most people could correctly guess that the comma is the separator, you need to find an example to show you that. The book is rampant with omissions like this. Two pages later, they use an OPEN - FOR construct in an example without introducing it. That it can be used dynamically, i.e. with the query in a character string constructed at run time, is not only not mentioned in this section, but is not even mentioned in the chapter on Dynamic SQL.
This should be looked upon as a book of (simple) examples. It should be no one's text or reference.
I recommend the book, but know that you need to download the examples (nice format for the code btw).
Most Recent Customer Reviews
Very happy with this purchase and I got this book delivered before the estimated arrival date. Also the book looks like a brand new book without tear and no markings . Read morePublished 14 months ago by marudhupandian2003
Very good training and reference book. Scott Urman writes in a clear and concise fashion, easy to understand in an organized outline method.Published on April 15, 2013 by Enlightened
This purchased saved me more money than I could have ever imagined. Worked perfectly for my PL/SQL class -- just as well as the online ebook (which would have been much much more... Read morePublished on November 23, 2012 by Christine R. Smith
Yes, this book is an "official Oracle" book, yet it's significantly worse than the "PL/SQL Programming" book by Steven Feuerstein. Read morePublished on March 16, 2012 by Tomas Vondra
Excelente producto ofrece lo necesario para programadores y estudiantes; te permite lograr una gran experiencia con la herramienta desde lo fundamental que es la el conocimiento de... Read morePublished on November 10, 2011 by yoya
This is one of the wrost books i've ever read. It tries everything to confuse readers and to use 10 sentences to describe what one sentence can make clear. Read morePublished on January 1, 2011 by Rich
This is A poorly written book. The programming examples used in the book are not explained in any detail. Read morePublished on February 24, 2010 by openmind
I read through the first 5 chapters of this book and did not find the link to the examples. On page 18 there's an entire paragraph or two that talks about the online examples. Read morePublished on September 8, 2009 by TheOracle1001