Lesson 22. Working with Stored Procedures
In this lesson, you’ll learn what stored procedures are, why they are used, and how they are used. You’ll also look at the basic syntax for creating and using them.
Understanding Stored Procedures
Most of the SQL statements that we’ve used thus far are simple in that they use a single statement against one or more tables. Not all operations are that simple—often, multiple statements are needed to perform a complete operation. For example, consider the following scenario:
To process an order, checks must be made to ensure that items are in stock.
If items are in stock, they need to be reserved so they ...
Get Oracle PL/SQL in 10 Minutes, Sams Teach Yourself now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
