When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Software Development
pluralsight logo

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages

This course will help you acquire certification for the Oracle Database Program with PL/SQL exam number 1Z0-149. It will cover the exam objectives of working with packages in Oracle PL/SQL.

     0 |
  • Reviews ( 0 )
Free
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages

Popular Courses

This Course Includes

  • iconpluralsight
  • icon0 (0 reviews )
  • icon1 hour 5 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcore courses
  • iconpluralsight

About Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages

This course will help you prepare for your PL/SQL certification by making you proficient with the exam objective of working with packages in PL/SQL.

In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages, you’ll learn how to effectively use packages in your PL/SQL code.

First, you’ll look at how we can use package variables and constants in other programs and how we can use them to maintain the session state.

Next, you’ll see how we can use the package constants and functions in SQL.

Finally, you’ll explore the ACCESSIBLE BY clause which is used to restrict access to the package subprograms by other PL/SQL units.

When you’re finished with this course, you’ll have a good knowledge of working with packages in Oracle PL/SQL, which should help you ace that section of the Oracle Database Program with PL/SQL exam number 1Z0-149.

What You Will Learn?

  • Course Overview : 1min.
  • Introduction : 6mins.
  • Use Package Types and Variables : 28mins.
  • Use Package Constants and Functions in SQL : 12mins.
  • Use ACCESSIBLE BY to Restrict Access to Package Subprograms : 16mins.