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.
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
audiobook
Technically Wrong
Buying groceries, tracking our health, finding a date: whatever we want to do, odds are that …
book
Java Projects - Second Edition
Learn how to build scalable, resilient, and effective applications in Java that suit your software requirements. …
video
Angular - The Complete Guide [2023 Edition]
If you are looking to become a proficient Angular developer and build modern, responsive, and scalable …
video
React - The Complete Guide (Includes Hooks, React Router, and Redux) - Second Edition
**This course is now updated for the latest version of React—React 18** React.js is the most …