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.
Learning Journey Context
Designed for experienced practitioners. We recommend having a solid grasp of Software Development fundamentals before starting this specialization.
Relevant for professionals pursuing roles within Software Development.
Quick Facts
What Youâll Learn
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.
Outcomes
- 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.
FAQs
Top Alternatives
Highly-rated courses worth your attention
