Throughout this course, you have had the opportunity to execute queries for the various types of object tables.
This module will focus on the Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE for object tables with and without the reference (REF) operator.
DML statements on object tables are similar to statements on normal relational tables;
however, there are some subtle differences, which we will review in the following lessons.
DML - Data Manipulation Language: INSERT, UPDATE, and DELETE statements are DML statements.
When you have completed this module, you will be able to:
Define important concepts for modifying object tables
Write Structured Query Language (SQL) to insert a row into an object table
Insert rows into sub queries
Write SQL to update object tables
Delete rows using SQL
In the next lesson, we will describe some key concepts for modifying object tables.