Featured resource
2026 Tech Forecast
2026 Tech Forecast

Stay ahead of what’s next in tech with predictions from 1,500+ business leaders, insiders, and Pluralsight Authors.

Get these insights
  • Course

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms

Subprograms are a fundamental concept in PL/SQL. This course will teach you how to create and use subprograms, and why they are important in an application. It will improve your coding skills and help you become an Oracle Certified Professional.

Intermediate
49m
(11)

Created by Lucian Lazar

Last Updated Mar 04, 2022

Course Thumbnail
  • Course

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms

Subprograms are a fundamental concept in PL/SQL. This course will teach you how to create and use subprograms, and why they are important in an application. It will improve your coding skills and help you become an Oracle Certified Professional.

Intermediate
49m
(11)

Created by Lucian Lazar

Last Updated Mar 04, 2022

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

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.

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms
Intermediate
49m
(11)
Table of contents

About the author
Lucian Lazar - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms
Lucian Lazar
10 courses 4.6 author rating 23 ratings

Lucian is a software developer and teaching assistant passionate about mentoring others in Oracle databases, PL/SQL programming and performance tuning.

Get started with Pluralsight