Book 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.
Tips point out shortcuts and
solutions.
Cautions help you avoid common pitfalls.
Notes explain additional concepts and provide additional
information.
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
Table of contents
- About This eBook
- Title Page
- Copyright Page
- Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- Lesson 1. Understanding SQL
- Lesson 2. Getting Started with Oracle and PL/SQL
- Lesson 3. Working with Oracle
- Lesson 4. Retrieving Data
- Lesson 5. Sorting Retrieved Data
- Lesson 6. Filtering Data
- Lesson 7. Advanced Data Filtering
- Lesson 8. Using Wildcard Filtering
- Lesson 9. Searching Using Regular Expressions
- Lesson 10. Creating Calculated Fields
- Lesson 11. Using Data Manipulation Functions
- Lesson 12. Summarizing Data
- Lesson 13. Grouping Data
- Lesson 14. Working with Subqueries
- Lesson 15. Joining Tables
- Lesson 16. Creating Advanced Joins
- Lesson 17. Combining Queries
- Lesson 18. Inserting Data
- Lesson 19. Updating and Deleting Data
- Lesson 20. Creating and Manipulating Tables
- Lesson 21. Using Views
- Lesson 22. Working with Stored Procedures
- Lesson 23. Using Cursors
- Lesson 24. Using Triggers
- Lesson 25. Managing Transaction Processing
- Lesson 26. Managing Security
- Appendix A. The Example Tables
- Appendix B. Oracle PL/SQL Datatypes
- Appendix C. Oracle PL/SQL Reserved Words and Keywords
- Index
- Code Snippets
Product information
- Title: Oracle PL/SQL in 10 Minutes, Sams Teach Yourself
- Author(s):
- Release date: September 2015
- Publisher(s): Sams
- ISBN: 9780768681987
You might also like
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
book
Practical SQL
"Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming …
book
Learning SQL, 3rd Edition
As data floods into your company, you need to put it to work right away—and SQL …