Rosenblum / Dorsey Oracle PL / SQL For Dummies

1. Auflage 2011
ISBN: 978-1-118-05479-6
Verlag: John Wiley & Sons
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 432 Seiten, E-Book

Find tips for creating efficient PL/SQL code
If you know a bit about SQL, this book will make PL/SQLprogramming painless!
The Oracle has spoken--you need to get up to speed onPL/SQL programming, right? We predict it'll be a breeze with thisbook! You'll find out about code structures, best practices, andcode naming standards, how to use conditions and loops, where toplace PL/SQL code in system projects, ways to manipulate data, andmore.
Discover how to
* Write efficient, easy-to-maintain code
* Test and debug PL/SQL routines
* Integrate SQL and PL/SQL
* Apply PL/SQL best practices
* Use new features introduced in Oracle 9i and 10g

Autoren/Hrsg.

Rosenblum, Michael

Dorsey, Paul

Inhaltsverzeichnis

Introduction.
Part I: Basic PL/SQL Concepts.
Chapter 1: PL/SQL and Your Database.
Chapter 2: The PL/SQL Environment.
Part II: Getting Started with PL/SQL.
Chapter 3: Laying the Groundwork: PL/SQL Fundamentals.
Chapter 4: Controlling Program Flow.
Chapter 5: Handling Exceptions.
Chapter 6: PL/SQL and SQL Working Together.
Part III: Standards and Structures.
Chapter 7: Putting Your Code in the Right Place.
Chapter 8: Creating Naming Standards.
Chapter 9: Creating Coding Standards.
Part IV: PL/SQL Data Manipulations.
Chapter 10: Basic Datatypes.
Chapter 11: Advanced Datatypes.
Part V: Taking PL/SQL to the Next Level.
Chapter 12: Transaction Control.
Chapter 13: Dynamic SQL and PL/SQL.
Chapter 14: PL/SQL Best Practices.
Part VI: The Part of Tens.
Chapter 15: Ten PL/SQL Tips.
Chapter 16: Ten Common Mistakes to Avoid in PL/SQL.
Index.

Über Autor(innen)

Michael Rosenblum is originally from Kremenchuk, Ukraine. In2000, he moved to the United States, where he lives with his familyin Edison, New Jersey. He works as a Development DBA at Dulcian,Inc. Michael is responsible for system tuning and applicationarchitecture. He also supports Dulcian developers by writingcomplex PL/SQL routines and researching new features. He is afrequent presenter at various regional and national Oracle usergroup conferences.
In his native Ukraine, he received the scholarship of the Presidentof Ukraine, a Masters Degree in Information Systems, and a Diplomawith Honors from the Kiev National University of Economics,Ukraine.
Dr. Paul Dorsey is the founder and President of Dulcian,Inc. (www.dulcian.com), an Oracle consulting firm that specializesin business rules-based Oracle Client-Server and Web customapplication development. He is the chief architect ofDulcian's Business Rules Information Manager (BRIM®)tool.
Paul is the co-author of seven Oracle Press books that have beentranslated into nine languages: Oracle JDeveloper 10gHandbook, Oracle9i JDeveloper Handbook, Oracle JDeveloper 3Handbook, Oracle Designer Handbook (2 editions), OracleDeveloper Forms and Reports: Advanced Techniques and DevelopmentStandards, Oracle8 Design Using UML Object Modeling. In2003, he was honored by ODTUG as volunteer of the year, in 2001 byIOUG as volunteer of the year and by Oracle as one of the sixinitial honorary Oracle 9i Certified Masters. Paul is anOracle Fusion Middleware Regional Director. He is the President ofthe New York Oracle Users' Group and a Contributing Editor ofthe International Oracle User Group's SELECT Journal. He isalso the founder and chairperson of the ODTUG Business RulesSymposium (now called Best Practices Symposium), currently in itssixth year, and the J2EE SIG.