PL/SQL   «Prev  Next»
Lesson 1

Introduction to Data Manipulation Language Statements, modifying Object Tables

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)[1] 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.

Module objectives

When you have completed this module, you will be able to:
  1. Define important concepts for modifying object tables
  2. Write Structured Query Language (SQL) to insert a row into an object table
  3. Insert rows into sub queries
  4. Write SQL to update object tables
  5. Delete rows using SQL
In the next lesson, we will describe some key concepts for modifying object tables.
[1] DML - Data Manipulation Language: INSERT, UPDATE, and DELETE statements are DML statements.