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.

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing Dependencies
Oracle dependencies are created between two objects when an object’s name appears in a SQL statement stored in another object. This course will teach you how to manage these dependencies.

Related Courses
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Declaring PL/SQL Variables (⭐ 4 | Reviews 12)
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Using PL/SQL Subprograms (⭐ 0 | Reviews 0)
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Working with Packages (⭐ 0 | Reviews 0)
This Course Includes
pluralsight
0 (0 reviews )
1 hour 3 minutes
english
Online - Self Paced
core courses
pluralsight
About Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing Dependencies
Some oracle objects in their definitions include references to other objects such as tables, views or procedures. As a result, the objects being defined are dependent on the objects referenced in their definitions.
Creating references is a must for certain objects like views and it also enables users to reuse existing code that can drastically reduce the time spent on development, review and testing. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing Dependencies, you will learn how to address these issues.
First, you'll learn about the relations between referenced and dependent objects.
Next, you’ll explore direct and indirect local dependencies and the objects involved.
Finally, you’ll look at guidelines for creating and best practices for recompiling objects.
When you’ve finished this course, you’ll have the skills and knowledge to approach oracle dependencies for your application and also you will be ready for taking the Managing Dependencies section in the 1Z0-149 exam.
What You Will Learn?
- Course Overview : 1min.
- Getting started with Dependencies : 12mins.
- Local Dependencies : 13mins.
- Remote dependencies : 20mins.
- Invalidation : 15mins.