Description:

It offers straightforward, practical answers when you need fast results.By working through the book?s 26 lessons of 10 minutes or less, you?ll learn what you need to know to take advantage of Oracle?s PL/SQL language.

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, sub queries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.

learn how to…

  • Use PL/SQL in the Oracle environments and tools
  • Construct complex PL/SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use string, date-time, and math functions to manipulate your data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, cursors, triggers, and more

Table Of Contents:

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