Subprograms are fundamental concepts in PL/SQL because they are the small and reusable parts of applications. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 – Using PL/SQL Subprograms, you’ll learn how to create and use PL/SQL subprograms. First, you’ll explore the most basic type of code, the anonymous blocks. Next, you’ll discover the subprograms and the benefits of using them in applications. Finally, you’ll learn the similarities and differences between anonymous blocks and subprograms. When you’ve finished with this course, you’ll have the skills and knowledge to create and to use PL/SQL subprograms and you will be ready for taking the subprograms section in the 1Z0-149 exam to become an Oracle Certified Professional in PL/SQL programming.
Author Name: Lucian Lazar
Author Description:
Lucian is passionate about learning new concepts and sharing knowledge. He has over 15 years of software development experience and over 5 years of experience in academic teaching. His focus is on database development, PL/SQL programming and performance tuning. He enjoys teaching and mentoring others so they can upgrade their skills and be successful.

Table of Contents

• Course Overview
  1min
• Anonymous Blocks
  12mins
• Subprograms
  24mins
• Compare Anonymous Blocks with Subprograms
  11mins