Expanded Library

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Procedures and Using Parameters

by Mike McQuillan

This course will teach you how to create and use stored procedures in Oracle Database. It covers the key information you will need to ace the stored procedures section of Oracle exam 1Z0-149.

What you'll learn

Are you taking the Oracle 1Z0-149 exam, or just want to know about Oracle stored procedures? In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Procedures and Using Parameters, you’ll learn how to create, use, and view stored procedures. First, you’ll explore how to create, change and drop stored procedures. Next, you’ll discover ways to execute stored procedures and how to super-charge them using parameters! Finally, you’ll learn how to handle any exceptions your stored procedures might encounter (we all have to deal with them!). When you’re finished with this course, you’ll have the skills and knowledge of Oracle Database needed to use and manage stored procedures, allowing you to ace that part of the Oracle 1Z0-149 exam..

About the author

Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.

Ready to upskill? Get started