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

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.

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..

• Course Overview 1min
• Introducing Stored Procedures 17mins
• Executing Stored Procedures and Using Parameters 20mins
• Exception Handling 16mins
• Displaying Procedure Information 11mins