Welcome to Database Administration Features.
This course introduces you to the object-oriented paradigm within the context of Oracle, then focuses on the SQL and PL/SQL commands for creating, modifying, and manipulating data within objects such as object tables and related object tables.
This course also covers
- nested tables,
- object types, and
- objects embedded
within relational tables. You will learn the steps necessary to create and use methods written in PL/SQL to manipulate data within objects. This is the first course in the five-part Oracle New Features Certification Series.
Taken in conjunction with the other courses within this website, this course will prepare you to pass the Oracle Features for Administrators
Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.
Oracle still uses an object-oriented paradigm for its PL/SQL constructs. Object types were introduced in Oracle Database 7, and they provide a way to create and manipulate object-oriented data in the database. Object types can be used to model real-world objects, such as customers, products, and orders. They can also be used to encapsulate data and behavior, and to create reusable software components.
PL/SQL also supports other object-oriented features, such as inheritance, polymorphism, and dynamic binding. This allows developers to build complex object-oriented applications using PL/SQL.
Here are some examples of how object-oriented programming can be used in PL/SQL:
- Modeling real-world objects:** An object type can be used to model a real-world object, such as a customer. The object type can define the attributes of the customer, such as name, address, and phone number. It can also define methods for manipulating the customer data, such as adding a new customer or updating an existing customer's information.
- Encapsulating data and behavior:** Object types can be used to encapsulate data and behavior. This means that the data and the methods for manipulating the data are hidden inside the object type. This can help to improve the security and maintainability of the code.
- Creating reusable software components:** Object types can be used to create reusable software components. This can save time and effort when developing new applications.
Overall, object-oriented programming is a powerful paradigm that can be used to build complex and maintainable PL/SQL applications.