Oralce PL/SQL编程 第6版（影印版） PDF下载

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 VersionsPreface<；br />；
Partl. ； Programming in PL/SQL<；br />；
1. Introduction to PL/SQL<；br />；
What Is PL/SQL?<；br />；
The Origins of PL/SQL<；br />；
The Early Years of PL/SQL<；br />；
Improved Application Portability<；br />；
Improved Execution Authority and Transaction Integrity<；br />；
Humble Beginnings, Steady Improvement<；br />；
So This Is PL/SQL<；br />；
Integration with SQL<；br />；
Control and Conditional Logic<；br />；
When Things Go Wrong<；br />；
About PL/SQL Versions<；br />；
Oracle Database 12c New PL/SQL Features<；br />；
Resources for PL/SQL Developers<；br />；
The OReilly PL/SQL Series<；br />；
PL/SQL on the Internet<；br />；
Some Words of Advice<；br />；
Don	 Be in Such a Hurry!<；br />；
Don	 Be Afraid to Ask for Help<；br />；
Take a Creative, Even Radical Approach<；br />；
2. Creating and Running PL/SQL Code<；br />；
Navigating the Database<；br />；
Creating and Editing Source Code<；br />；
SQL*Plus<；br />；
Starting Up SQL*Plus<；br />；
Running a SQL Statement<；br />；
Running a PL/SQL Program<；br />；
Running a Script<；br />；
What Is the "Current Directory"?<；br />；
Other SQL*Plus Tasks<；br />；
Error Handling in SQL*Plus<；br />；
Why You Will Love and Hate SQL*Plus<；br />；
Performing Essential PL/SQL Tasks<；br />；
Creating a Stored Program<；br />；
Executing a Stored Program<；br />；
Showing Stored Programs<；br />；
Managing Grants and Synonyms for Stored Programs<；br />；
Dropping a Stored Program<；br />；
Hiding the Source Code of a Stored Program<；br />；
Editing Environments for PL/SQL<；br />；
Calling PL/SQL from Other Languages<；br />；
C: Using Oracles Precompiler (Pro*C)<；br />；
Java: Using JDBC<；br />；
Perl: Using Perl DBI and DBD::Oracle<；br />；
PHP: Using Oracle Extensions<；br />；
PL/SQL Server Pages<；br />；
And Where Else?<；br />
3. Language Fundamentals<br />
PL/SQL Block Structure<br />
Anonymous Blocks<br />
Named Blocks<br />
Nested Blocks<br />
Scope<br />
Qualify All References to Variables and Columns in SQL Statements<br />
Visibility<br />
The PL/SQL Character Set<br />
Identifiers<br />
Reserved Words<br />
Whitespace and Keywords<br />
Literals<br />
NULLs<br />
Embedding Single Quotes Inside a Literal String<br />
Numeric Literals<br />
Boolean Literals<br />
The Semicolon Delimiter<br />
……