Chapter 1: Understanding SQL
Chapter 2: Getting Started with Oracle and PL/SQL
Chapter 3: Working with Oracle1
Chapter 4: Retrieving Data
Chapter 5: Sorting Retrieved Data
Chapter 6: Filtering Data
Chapter 7: Advanced Data Filtering1
Chapter 8: Using Wildcard Filtering
Chapter 9: Searching Using Regular Expressions
Chapter 10: Creating Calculated Fields
Chapter 11: Using Data Manipulation Functions
Chapter 12: Summarizing Data
Chapter 13: Grouping Data
Chapter 14: Working with Sub queries
Chapter 15: Joining Tables
Chapter 16: Creating Advanced Joins
Chapter 17: Combining Queries
Chapter 18: Inserting Data
Chapter 19: Updating and Deleting Data
Chapter 20: Creating and Manipulating Tables
Chapter 21: Using Views
Chapter 22: Working with Stored Procedures
Chapter 23: Using Cursors
Chapter 24: Using Triggers
Chapter 25: Managing Transaction Processing
Chapter 26: Managing Security
Appendix A: The Example Tables
Appendix C: Oracle PL/SQL Reserved Words and Keywords
Chapter 2: Getting Started with Oracle and PL/SQL
Chapter 3: Working with Oracle1
Chapter 4: Retrieving Data
Chapter 5: Sorting Retrieved Data
Chapter 6: Filtering Data
Chapter 7: Advanced Data Filtering1
Chapter 8: Using Wildcard Filtering
Chapter 9: Searching Using Regular Expressions
Chapter 10: Creating Calculated Fields
Chapter 11: Using Data Manipulation Functions
Chapter 12: Summarizing Data
Chapter 13: Grouping Data
Chapter 14: Working with Sub queries
Chapter 15: Joining Tables
Chapter 16: Creating Advanced Joins
Chapter 17: Combining Queries
Chapter 18: Inserting Data
Chapter 19: Updating and Deleting Data
Chapter 20: Creating and Manipulating Tables
Chapter 21: Using Views
Chapter 22: Working with Stored Procedures
Chapter 23: Using Cursors
Chapter 24: Using Triggers
Chapter 25: Managing Transaction Processing
Chapter 26: Managing Security
Appendix A: The Example Tables
Appendix C: Oracle PL/SQL Reserved Words and Keywords