Oracle PL/SQL in 10 Minutes, Sams Teach Yourself

About

Features

• Teaches everything students need to know to take advantage of Oracle's PL/SQL language
• Offers straightforward, highly-focused, ten-minute lessons to make readers immediately and effortlessly productive in PL/SQL
• Covers Oracle DBMS versions 10, 11, 12, and XE (Express Edition) on all platforms, with differences clearly noted

Description

Covers Oracle DBMS versions 10, 11, 12, and XE

Sams Teach Yourself Oracle PL/SQL in 10 Minutes 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, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.

10 minutes is all you need to 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

Extras

Author's Site

Visit the author's website at www.benforta.com/books.

Sample Content

Sample Pages

Download the sample pages (includes Chapter 4 and Index)

Table of Contents

• Introduction
• Chapter 1: Understanding SQL  
• Chapter 2: Getting Started with Oracle and PL/SQL 
• Chapter 3: Working with Oracle  
• Chapter 4: Retrieving Data
• Chapter 5: Sorting Retrieved Data  
• Chapter 6: Filtering Data 
• Chapter 7: Advanced Data Filtering  
• 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 Subqueries
• 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 B: Oracle PL/SQL Datatypes
• Appendix C: Oracle PL/SQL Reserved Words and Keywords
• Index

Updates

Submit Errata