RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next

Course navigation
Lesson 1
Modifying object tables

 
By now you should have a good understanding of Oracle’s approach. Throughout this course, you’ve had the opportunity for hands-on application by querying the various types of object tables. In this module, we will turn our focus to 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.

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.

Course navigation