Manipulating Data in Oracle Database 10g


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.8

Lesson Objectives

Manipulating Data in Oracle Database 10g

  • insert rows into a table.
  • update and delete rows in a table.
  • insert, update, and delete data.
  • control data changes and identify how read consistency is implemented.
  • control data changes using the COMMIT, SAVEPOINT, and ROLLBACK statements.
  • manipulate data in Oracle 10g by using subqueries.
  • use various types of multitable inserts.
  • use the MERGE statement and the Flashback Version Query feature.
  • perform multitable INSERT and MERGE operations, and track row versions.
  • Course Number:
    223297_eng