List of Tables

Title and Copyright Information


Changes in Oracle Database 12c Release 2 (12.2)

Part I Database Development Fundamentals

1 Design Basics

2 Connection Strategies for Database Applications

3 Performance and Scalability

4 Designing Applications for Oracle Real-World Performance

5 Security

6 High Availability

7 Advanced PL/SQL Features

Part II SQL for Application Developers

8 SQL Processing for Application Developers

9 Using SQL Data Types in Database Applications

10 Using Regular Expressions in Database Applications

11 Using Indexes in Database Applications

12 Maintaining Data Integrity in Database Applications

Part III PL/SQL for Application Developers

13 Coding PL/SQL Subprograms and Packages

14 Using PL/Scope

15 Using the PL/SQL Hierarchical Profiler

16 Using PL/SQL Basic Block Coverage to Maintain Quality

17 Developing PL/SQL Web Applications

18 Using Continuous Query Notification (CQN)

Part IV Advanced Topics for Application Developers

19 Using Oracle Flashback Technology

20 Choosing a Programming Environment

21 Developing Applications with Multiple Programming Languages

22 Developing Applications with Oracle XA

23 Developing Applications with the Publish-Subscribe Model

24 Using the Oracle ODBC Driver

25 Using the Identity Code Package

26 Understanding Schema Object Dependency

27 Using Edition-Based Redefinition

28 Using Transaction Guard