作者简介 Steven Feuerstein被认为是世界上Oracle PL/SQL语言方面的非常不错专家之一。Steven从1990年就开始编写PL/SQL语言相关书籍并为开发人员进行培训。他在这个方向出版了十本书,包括《Oracle PL/SQL Best Practices》。 Bill Pribyl是一名作家、讲师和软件咨询师。他是《LearningOracle PL/SQL》的作者,也是《Oracle PL/SQL Programming)>和《Oracle PL/SQL Language Pocket Reference》的作者之一。
目录 Preface Partl. Programming in PL/SQL 1. Introduction to PL/SQL What Is PL/SQL? The Origins of PL/SQL The Early Years of PL/SQL Improved Application Portability Improved Execution Authority and Transaction Integrity Humble Beginnings, Steady Improvement So This Is PL/SQL Integration with SQL Control and Conditional Logic When Things Go Wrong About PL/SQL Versions Oracle Database 12c New PL/SQL Features Resources for PL/SQL Developers The OReilly PL/SQL Series PL/SQL on the Internet Some Words of Advice Dont Be in Such a Hurry! Dont Be Afraid to Ask for Help Take a Creative, Even Radical Approach 2. Creating and Running PL/SQL Code Navigating the Database Creating and Editing Source Code SQL*Plus Starting Up SQL*Plus Running a SQL Statement Running a PL/SQL Program Running a Script What Is the "Current Directory"? Other SQL*Plus Tasks Error Handling in SQL*Plus Why You Will Love and Hate SQL*Plus Performing Essential PL/SQL Tasks Creating a Stored Program Executing a Stored Program Showing Stored Programs Managing Grants and Synonyms for Stored Programs Dropping a Stored Program Hiding the Source Code of a Stored Program Editing Environments for PL/SQL Calling PL/SQL from Other Languages C: Using Oracles Precompiler (Pro*C) Java: Using JDBC Perl: Using Perl DBI and DBD::Oracle PHP: Using Oracle Extensions PL/SQL Server Pages And Where Else? 3. Language Fundamentals PL/SQL Block Structure Anonymous Blocks Named Blocks Nested Blocks Scope Qualify All References to Variables and Columns in SQL Statements Visibility The PL/SQL Character Set Identifiers Reserved Words Whitespace and Keywords Literals NULLs Embedding Single Quotes Inside a Literal String Numeric Literals Boolean Literals The Semicolon Delimiter ……
以下为对购买帮助不大的评价