Free Downloads
Oracle Database 10g PL/SQL Programming

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.

Series: Oracle Press

Paperback: 896 pages

Publisher: McGraw-Hill Education; 1st edition (October 7, 2004)

Language: English

ISBN-10: 0072230665

ISBN-13: 978-0072230666

Product Dimensions: 7.3 x 1.7 x 9.2 inches

Shipping Weight: 3.2 pounds (View shipping rates and policies)

Average Customer Review: 3.9 out of 5 stars  See all reviews (29 customer reviews)

Best Sellers Rank: #599,563 in Books (See Top 100 in Books) #149 in Books > Computers & Technology > Databases & Big Data > Oracle #323 in Books > Computers & Technology > Databases & Big Data > SQL #3975 in Books > Computers & Technology > Programming > Languages & Tools

SQL developers experienced with non-Oracle databases or Oracle developers who are looking for a good reference manual should definitely pick up a copy of this book. Inexperienced SQL developers will probably get more out of Oracle Press' other excellent book PL/SQL 101.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 bought this book hoping it would help me pass the 1Z0-147 Oracle PL/SQL certification test, and it did. First the bad news: chapters five and six are horrible. The person that wrote these two chapters writes in the most pedantic way possible. Pages upon pages are filled with highly repetitive code, with each example followed by a detailed analysis of every statement! Compare this to the coding examples in other chapters, where statements of interest are highlighted and then followed by descriptions of their significance. If you want a laugh, check out page 225, where the author of chapter six says, "A problem with programming books is that concepts need to be illustrated with an economy of space." Wow.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 a large survey of the PL/SQL language and introduces many new things that have changed with 10g. But there is a major problem with the book, which runs throughout almost all Oracle Documentation.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 got the book for some of the new 10g features and have found it helpful. The examples were very great once I found them. After some digging I found the code for the examples online, but according to there was supposed to be a cd...WHERE??I recommend the book, but know that you need to download the examples (nice format for the code btw).

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Oracle Database 10g PL/SQL Programming Programming: Computer Programming for Beginners: Learn the Basics of Java, SQL & C++ - 3. Edition (Coding, C Programming, Java Programming, SQL Programming, JavaScript, Python, PHP) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Oracle Database 10g DBA Handbook OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 11g SQL (Oracle Press) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) SQL Handbook: Learning The Basics Of SQL Programming (Computer Science Programming) (Computer Programming For Beginners) FORTRAN Programming success in a day:Beginners guide to fast, easy and efficient learning of FORTRAN programming (Fortran, Css, C++, C, C programming, ... Programming, MYSQL, SQL Programming) Oracle Database 12c PL/SQL Programming Programming #8:C Programming Success in a Day & Android Programming In a Day! (C Programming, C++programming, C++ programming language, Android , Android Programming, Android Games) Programming #57: C++ Programming Professional Made Easy & Android Programming in a Day (C++ Programming, C++ Language, C++for beginners, C++, Programming ... Programming, Android, C, C Programming) HOWTO Secure and Audit Oracle 10g and 11g Programming #45: Python Programming Professional Made Easy & Android Programming In a Day! (Python Programming, Python Language, Python for beginners, ... Programming Languages, Android Programming) Oracle SQL Tuning with Oracle SQLTXPLAIN ORACLE PL/SQL 101 (Oracle Press) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press)