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 - 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.

Intermediate
1h 3m
(1)

Created by Alexandru Huiban

Last Updated Jun 22, 2022

Course Thumbnail
  • Course

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.

Intermediate
1h 3m
(1)

Created by Alexandru Huiban

Last Updated Jun 22, 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

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.

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing Dependencies
Intermediate
1h 3m
(1)
Table of contents

About the author
Alexandru Huiban - Pluralsight course - Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing Dependencies
Alexandru Huiban
2 courses 0.0 author rating 0 ratings

Alex is a database developer and eternal tinkerer. He is passionate about Oracle databases but also about the endless uses for systemes on a chip.

Get started with Pluralsight