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..
Author Name: Mike McQuillan
Author Description:
Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he’s working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doe… more

Table of Contents

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