Like the previous edition, this tutorial is an integrated learning solution that teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects. Completely updated for Oracle 12c, it covers all the fundamentals, from PL/SQL syntax and program control through packages and optimization. This book’s approach reflects the authors’ award-winning experience teaching PL/SQL programming to professionals. Providing readers with the accompanying schema that can be used for practice allows the authors to explain PL/SQL concepts through…mehr
Like the previous edition, this tutorial is an integrated learning solution that teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects. Completely updated for Oracle 12c, it covers all the fundamentals, from PL/SQL syntax and program control through packages and optimization.
This book’s approach reflects the authors’ award-winning experience teaching PL/SQL programming to professionals. Providing readers with the accompanying schema that can be used for practice allows the authors to explain PL/SQL concepts through examples. Each concept is explained first, then illustrated via examples and interactive labs that introduce topics about Oracle PL/SQL. The topics are discussed briefly and then explored through exercises. Each exercise consists of a series of steps followed to perform a specific task, along with questions designed to help you discover the important things about PL/SQL programming on your own. The answers to the questions are then given with more in-depth discussion of the topics. In this way the answers are not just solutions to the exercises but a continuation of the learning process. The exercises are intended to act as your guide to walk you through a particular task. Finally, at the end of each chapter there is a "Test Your Thinking" section made up of a series of projects designed to solidify all of the skills learned in the chapter.
Key topics covered include:
Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statementsHinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Benjamin Rosenzweig is a Senior Project Manager at Misys Financial Software, where he has worked since 2002. Prior to that he was a principal consultant for more than three years at Oracle Corporation in the Custom Development Department. His computer experience ranges from creating an electronic Tibetan—English Dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing a trading system at TIAA-CREF. Benjamin has been an instructor at the Columbia University Computer Technology and Application program in New York City since 1998. In 2002 he was awarded the “Outstanding Teaching Award” from the Chair and Director of the CTA program. He holds a B.A. from Reed College and a certificate in database development and design from Columbia University. His previous books with Prentice Hall are Oracle Forms Developer: The Complete Video Course (2000), and Oracle Web Application Programming for PL/SQL Developers (2003). Elena Rakhimov has more than twenty years of experience in database architecture and development in a wide spectrum of enterprise and business environments ranging from non-profit organizations to Wall Street to her current position with a prominent software company where she heads up the database team. Her determination to stay “hands-on” notwithstanding, Elena managed to excel in the academic arena having taught relational database programming at Columbia University’s highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan. She currently resides in Vancouver, Canada.
Inhaltsangabe
Preface xvii Acknowledgments xxi About the Authors xxiii Introduction to PL/SQL New Features in Oracle 12c xxv Invoker’s Rights Functions Can Be Result-Cached xxvi More PL/SQL-Only Data Types Can Cross the PL/SQL-to-SQL Interface Clause xxvii ACCESSIBLE BY Clause xxvii FETCH FIRST Clause xxviii Roles Can Be Granted to PL/SQL Packages and Stand-Alone Subprograms xxix More Data Types Have the Same Maximum Size in SQL and PL/SQL xxx Database Triggers on Pluggable Databases xxx LIBRARY Can Be Defined as a DIRECTORY Object and with a CREDENTIAL Clause xxx Implicit Statement Results xxxi BEQUEATH CURRENT_USER Views xxxii INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges xxxii Invisible Columns xxxiii Objects, Not Types, Are Editioned or Noneditioned xxxiv PL/SQL Functions That Run Faster in SQL xxxiv Predefined Inquiry Directives $$PLSQL_UNIT_OWNER and $$PLSQL_UNIT_TYPE xxxvi Compilation Parameter PLSQL_DEBUG Is Deprecated xxxvii
Preface xvii Acknowledgments xxi About the Authors xxiii Introduction to PL/SQL New Features in Oracle 12c xxv Invoker’s Rights Functions Can Be Result-Cached xxvi More PL/SQL-Only Data Types Can Cross the PL/SQL-to-SQL Interface Clause xxvii ACCESSIBLE BY Clause xxvii FETCH FIRST Clause xxviii Roles Can Be Granted to PL/SQL Packages and Stand-Alone Subprograms xxix More Data Types Have the Same Maximum Size in SQL and PL/SQL xxx Database Triggers on Pluggable Databases xxx LIBRARY Can Be Defined as a DIRECTORY Object and with a CREDENTIAL Clause xxx Implicit Statement Results xxxi BEQUEATH CURRENT_USER Views xxxii INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges xxxii Invisible Columns xxxiii Objects, Not Types, Are Editioned or Noneditioned xxxiv PL/SQL Functions That Run Faster in SQL xxxiv Predefined Inquiry Directives $$PLSQL_UNIT_OWNER and $$PLSQL_UNIT_TYPE xxxvi Compilation Parameter PLSQL_DEBUG Is Deprecated xxxvii
