Free Oracle Database 11g PL/SQL Programming (Oracle Press) Ebooks Online

                
              
Free 
Oracle Database 11g PL/SQL Programming (Oracle Press) Ebooks Online
Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.Create, debug, and manage Oracle-driven PL/SQL programsUse PL/SQL structures, delimiters, operators, variables, and statementsIdentify and eliminate errors using PLSQL_WARNINGS and exception handlersWork with functions, procedures, packages, collections, and triggersDefine and deploy varray, nested table, and associative array data typesHandle external routines, object types, large objects, and secure filesCommunicate between parallel sessions using DBMS_ALERT and DBMS_PIPECall external procedures through Oracle Net Services and PL/SQL wrappersIntegrate internal and server-side Java class libraries using Oracle JVMDevelop robust Web applications using PL/SQL Gateway and Web Toolkit
Series: Oracle Press
Paperback: 835 pages
Publisher: McGraw-Hill Education; 1 edition (April 11, 2008)
Language: English
ISBN-10: 0071494456
ISBN-13: 978-0071494458
Product Dimensions:  7.1 x 1.7 x 9.1 inches
Shipping Weight: 3 pounds (View shipping rates and policies)
Average Customer Review:  3.9 out of 5 stars  See all reviews (26 customer reviews)
Best Sellers Rank: #510,590 in Books (See Top 100 in Books)   #34 in Books > Computers & Technology > Certification > Oracle   #118 in Books > Computers & Technology > Databases & Big Data > Oracle   #269 in Books > Computers & Technology > Databases & Big Data > SQL
This is the first technical/computing book that I have ever read cover to cover.In fact I read this book cover to cover with multiple iterations of chapters that were difficult for me (e.g., Chapter 6 Functions and Procedures, Chapter 8 Large Objects, Chapter 13, External Procedures, Chapter 14 Object Types and the PHP/Java Primers in Appendices C and D, respectively).I have been a PL/SQL Developer for over 6 years.I thought I was doing pretty well but it turns out I was doing a limited number of things in my development experience over and over again. The ease with which I was writing functions and procedures, organizing the same in packages and utilizing a very few of the more advanced features like BULK COLLECT and BULK UPDATE was a deceptive set of convenient facts: Thanks to this book I now know how much I didn't know and I have a more than vague feeling that even now my ship is still relatively close to shore. There is much more the the "sea of PL/SQL", if you'll allow me that much of a poetic license!I was particularly surprised to find out how little I knew about Oracle functions after having written so many over the years. Pipelined functions? I had never heard of them! Creation options? Eh...those either! I did not know you could used mixed notation to make a call to a procedure with multiple parameters.The book has some typographical/copy and paste-type issues which threw me off in the beginning. It's likely not the book as much as it is my personality: I'm a classically trained musician from another life (a MUCH younger life) so you can imagine that I might be predisposed to being a stickler for details.In the end, I finished this book because it was thorough, clear, deep (the way I like it!
Oracle Database 11g PL/SQL Programming by Michael McLaughlin. New York, 2008 by McGraw-Hill Companies, Inc.As business processes and problems rely more and more on reporting and data analysis from Oracle databases, there is an increasing need for personnel that have a working knowledge of the PL/SQL language. In this book, the author intends to teach those just beginning to learn PL/SQL the basic concepts through some of the more challenging capabilities of the language. McLaughlin does quite a respectable job of accomplishing this difficult task.Throughout the book a reader is supplied with example code that works as prescribed, personal experiences illustrating code hazards and successes for various applications, figures demonstrating how code works in complex situations, appendices abundant with relevant information for easy reference and finally even a bit of humor here and there. Although the intended audience is new users, experienced PL/SQL programmers would benefit as new features in 11g are explained and clarified with code examples.There are many ways to present methods for learning programming languages, ranging from brief explanations with code snippets to extraordinary or mind numbing details with few or no examples. In the former case many gaps exist and a reader is usually left without a clue as to how to use the language at all, let alone effectively. And in the latter case, by the time a reader finishes a paragraph she is left wondering how to use and apply the material in a realistic scenario. In this book McLaughlin balances the two extremes to provide a consistent method useful for both new and experienced programmers. Clearly and succinctly he presents a topic and then provides an easily understandable example.
Oracle Database 11g PL/SQL Programming Workbook (Oracle Press) Oracle Database 11g PL/SQL Programming (Oracle Press) OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL (Oracle Certification Prep) Study Guide for 1Z0-117: Oracle Database 11g Release 2: SQL Tuning (Oracle Certification Prep) OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) (Oracle Press) OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press) Study Guide for 1Z0-052: Oracle Database 11g: Administration I: Oracle Certification Prep Study Guide for 1Z0-053: Oracle Database 11g: Administration II (Oracle Certification Prep) Study Guide for 1Z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP: Oracle Certification Prep Oracle Database Administration for Microsoft SQL Server DBAs (Oracle Press) OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) Beginning SQL 2012 Joes 2 Pros Volume 1: The SQL Queries 2012 Hands-On Tutorial for Beginners (SQL Exam Prep Series 70-461 Volume 1 Of 5) (SQL Queries 2012 Joes 2 Pros) Oracle 11g: PL/SQL Programming Quick Start Guide to Oracle Fusion Development: Oracle JDeveloper and Oracle ADF (Oracle Press) Study Guide for 1Z0-071: Oracle Database 12c SQL: Oracle Certification Prep Study Guide for 1Z0-061: Oracle Database 12c: SQL Fundamentals (Oracle Certification Prep) OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) 