Steven Feuerstein被认为是世界上Oracle PL/SQL语言方面的权威专家之一。Steven从1990年就开始编写PL/SQL语言相关书籍并为开发人员进行培训。他在这个方向出版了十本书,包括《Oracle PL/SQL Best Practices》。
BillPribyl是一名作家、讲师和软件咨询师。他是《LearningOracle PL/SQL》的作者,也是《Oracle PL/SQL Programming和《Oracle PL/SQL Language Pocket Reference》的作者之一。
目錄:
Preface
Partl. Programming in PLSQL
1. Introduction to PLSQL
What Is PLSQL?
The Origins of PLSQL
The Early Years of PLSQL
Improved Application Portability
Improved Execution Authority and Transaction Integrity
Humble Beginnings, Steady Improvement
So This Is PLSQL
Integration with SQL
Control and Conditional Logic
When Things Go Wrong
About PLSQL Versions
Oracle Database 12c New PLSQL Features
Resources for PLSQL Developers
The O''Reilly PLSQL Series
PLSQL on the Internet
Some Words of Advice
Don''t Be in Such a Hurry!
Don''t Be Afraid to Ask for Help
Take a Creative, Even Radical Approach
2. Creating and Running PLSQL Code
Navigating the Database
Creating and Editing Source Code
SQL*Plus
Starting Up SQL*Plus
Running a SQL Statement
Running a PLSQL 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 PLSQL 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 PLSQL
Calling PLSQL from Other Languages
C: Using Oracle''s Precompiler Pro*C
Java: Using JDBC
Perl: Using Perl DBI and DBD::Oracle
PHP: Using Oracle Extensions
PLSQL Server Pages
And Where Else?
3. Language Fundamentals
PLSQL Block Structure
Anonymous Blocks
Named Blocks
Nested Blocks
Scope
Qualify All References to Variables and Columns in SQL Statements
Visibility
The PLSQL Character Set
Identifiers
Reserved Words
Whitespace and Keywords
Literals
NULLs
Embedding Single Quotes Inside a Literal String
Numeric Literals
Boolean Literals
The Semicolon Delimiter
……